As per the requirement, we are supposed to give a context variable in the place of delimiter and substitute the value "," in the context file.
Hence, in tinputfiledelimited I gave "context.delimiter" at the delimiter textbox and in the context file; i gave delimiter,,
(the file is comma delimiter). I encountered error, also i tried giving
I encountered error as well, can some provide me a solution on how to provide a context variable for a delimiter whose delimited value is ,
This is the error, I get while trying to execute the file with the context value as stated above.
Exception in component tfileinputdelimited_1
java.lang.IllegalArgumentException: Field Separator must be assigned a char.
Please advice me how to put the context variable in the context file so as to handle "," delimiter file in tinputfiledelimited.
Thanks for the reply,
Do you mean to put the context file as below?
(where ctxtdelimiter is the context variable for delimiter) and in the delimiter place (in tfileinputdelimiter_1) use context.ctxtdelimter in the place of delimiter text box
is my understanding correct?
in the contex change from String -> Character and set it ',' which is a character...
Also you could keep it as a String and simply use double quotes
So both worked,
Make sure in tFileInputDelimited just use
without ""+ it raises an error. I think a bug exists, I dont know why...
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Create systems and workflow to manage clean data ingestion and data transformation.