Generate Multiple Rows Headers to Output

[rockeylearning]

Hi

I seen other thread asking about multiple rows headers, but I can't seem to make it work on my end.

I created two Text Input with just headers row, my desire id for it to output two rows header in excel or csv.

I am using the Union, and selected Manual Configure Fields as Position, but it output only one row header from the first Input text. What am I doing wrong?

[binuacs]

@rockeylearning try this approach

[rockeylearning]

@binuacs sorry, I should have mentioned that there will be multiple Text Input and they will all have different Headers. How can I achieve this?

For example

Text Input 1: Column 1, Column 2, Column 3

Text Input 2: Column 1A, Column 2A, Column 3A

Text Input 3: Column 1B, Column 2B, Column 3B

Result

Column 1, Column 2, Column 3

Column 1A, Column 2A, Column 3A

Column 1B, Column 2B, Column 3B

<Data field next row etc..)

[binuacs]

@rockeylearning your input files are going to be text input files or excel/csv files?

[binuacs]

@rockeylearning to combine the headers you need to make these headings a rows in the input file

[rockeylearning]

@binuacs It is going to be excel

[binuacs · Accepted solution]

@rockeylearning in that case check the below options in the input tool, then union and with the help of the dynamic rename tool take the fields from the first row of data

[rockeylearning]

@binuacs Thank you for the different options. I'll test out both