Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Actually, we have a project requirement where we need to create a CSV file to be passed to a MDM system. Few columns of the CSV need to have a dot in the column header .
Eg: attributes.action , attributes.id etc.,
Being relatively new to Talend, I could not find any way to this from the components as Talend is not allowing that.
Any other way of achieving this. Any help/advice would be really helpful as its an urgent requirement.
Thanks
Hi
It is impossible to contain a 'dot' in the column name, the job will be translated into Java code, the column name will be a variable in the Java code. You can try to output the column header to the file first, and then append the data to the file in next subjob.
For example:
tFixeFlowInput--main--tFileOutputDelimited
|onsubjobok
...BABABA---tFileOutputDelimited(append the data the file without including the header)
tFixeFlowInput: define the column headers.
Regards
Shong