Nest multiple headers-details from sql tables to delimited file

[Anonymous]

Good evening. I'm extremely new here and relatively new to Talend. There's a problem I'm facing and I can't see to find a way to solve it:

I need to output an X number of columns from [Header_Table] to a file, then a bunch of columns from its corresponding [Detail_Table] underneath them, then the rest of the columns from [Header_Table] underneath those. In essence it's like this:

HDR1 Row 1: {HDR_Field_1}~{HDR_Field_2}~{HDR_Field_3}~{HDR_Field_4}

DTL Row 1: {DTL_Field_1}~{DTL_Field_2}~{DTL_Field_3}

DTL Row 2: {DTL_Field_1}~{DTL_Field_2}~{DTL_Field_3}

...

DTL Row n: {DTL_Field_1}~{DTL_Field_2}~{DTL_Field_3}

HDR1 Row 2: {HDR_Field_5}~{HDR_Field_6}

HDR2 Row 1: {HDR_Field_1}~{HDR_Field_2}~{HDR_Field_3}~{HDR_Field_4}

DTL Row 1: {DTL_Field_1}~{DTL_Field_2}~{DTL_Field_3}

DTL Row 2: {DTL_Field_1}~{DTL_Field_2}~{DTL_Field_3}

...

DTL Row n: {DTL_Field_1}~{DTL_Field_2}~{DTL_Field_3}

HDR2 Row 2: {HDR_Field_5}~{HDR_Field_6}

etc etc.

Has anyone ever had to do something similar before? Thanks in advance!

[Anonymous]

Hello,

What's your input source? Is it .sql file? Could you please give us some sample about it?

Best regards

Sabrina