Generate Multiple Rows Headers to Output

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?

Developer Tools

Accepted answers

binu_acs

@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

headers_22102024_Updated.yxzp

All comments

binu_acs

@rockeylearning try this approach

headers_22102024.yxmd

rockeylearning

@binu_acs 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..)

binu_acs

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

binu_acs

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

headers_22102024.yxmd

rockeylearning

@binu_acs It is going to be excel

binu_acs

@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

headers_22102024_Updated.yxzp

rockeylearning

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703