Headers missing on combining tFileOutputDelimited outputs in a single file

[Anonymous]

I created a workflow : tDBInput -> tMap -> tFileOutputDelimited. As tMap produces 5 different outputs, i have 5 tFileOutputDelimited connections created out of it and then updated config to update in single file. While doing that, i checked Append and Include Header checkbox. PFA screenshot. Generated file has header for 1st output only but subsequent headers are missing from the file. Also, observed that appending does not happen sequentially. It mixes up the output data in random manner. Any help on this issue is appreciated.

[manodwhb]

@Moe ,can you show your job design?

[Anonymous]

@manodwhb Sure. please find attached img.

img2.jpg

[David_Beaty]

Hi,

I'm not sure pushing 5 different outputs to the same file is a sensible idea? Consider pushing just 1 to the file directly, and the other 4 to 4 tHashOutput components, then read each of the 4 back in, and push to the file one at a time.

As an alternative, not sure if this will work, on the Advanced tab for each tFileOutputDelimited, tick the "Output in row mode" option.

[Anonymous]

Thanks @dsoulalioux for response. I tried with "Output in row mode" option in Advanced settings. it did not work.

[David_Beaty]

That was just a long shot.

Separating the flows out and then feeding them into the final file, one feed at a time is probably the only option.

[Anonymous]

Talend does not allow this kind of operation.