topic tFileOutputDelimited - Need column headers with a 'dot' as an urgent requirement in Talend Studio

tFileOutputDelimited - Need column headers with a 'dot' as an urgent requirement

Sriram151515 — Sat, 16 Nov 2024 00:52:54 GMT

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

Re: tFileOutputDelimited - Need column headers with a 'dot' as an urgent requirement

Anonymous — Mon, 11 Jan 2021 06:29:50 GMT

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