I have an issue related to the fact that I cannot find any solution to split one row from a Tmap component to multiple column (the number of column equal to the number of commas + 1).
It's easier with an example. I have this job:
tFileInputDelimited -> tMap -> tLogRow
The output (from the tMap) is:
col1, col2, col3, ...., col500
val1, val2, val3, ..., val500
Now, I want to split the first row in order to obtain 500 columns and for each column created, to associate the good value, i.e in col1 the val1, col2 the val2 etc.
I cannot create a schema the for the tFileInputDelimited because if I want to use another file with 600 columns instead of 500, this won't work properly.
Due to the fact that I have a large number of columns, I cannot "create by myself" via a .split in the Tmap the columns.
For information, I have Talend Open Studio, therefore, I cannot use the "dynamic schema" feature.
Thank you in advance
PS: I'm a beginner in Talend, therefore, I need details if you have a solution.