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!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema