Multiple Header rows

[Birdman1971]

Good day 

I have a requirement to transfer some data and have 2 rows containing header text . I have tried a couple of things but with no joy. 

Any simple solutions will be appreciated! 

Thank you in advance. 

[davidskaife]

Hi @Birdman1971 

Are you able to provide a sample dataset, may be easier for us to help if we can see the data

[Birdman1971]

I've not explained it very well - I need to add headers to the data and those headers are over two rows per column. I can of course add in a single line header and i have even included the text required for the second row to then try and move to the second row with success 

[GMG0241]

it's still a bit confusing to understand exactly what it is that you want to do. Please may you add an example of the transformation you're looking for? Please make sure you have both the example input and the example output for the transformation

[davidskaife · Accepted solution]

Hi @Birdman1971 

I think i understand what you're looking for, try this as an example way to do it:

Have the second headers in a separate file (or however they come in) and then Union them back to the main dataset - ensure you have the first input set to the main dataset, and specify the output order in that the second headers is first, followed by the rest of the data - it will automatically populate the headers correctly. In my example i've had to configure the columns manually, but it can be done automatically if both inputs have the same header names.

[Birdman1971]

I have attached a crude example of the data which has no headers - I need to include headers over two rows 

[davidskaife]

Hi @Birdman1971 

Thanks for the data - my solution above will still work, you just need to rename the headers on the data file to match for the first header row if that makes sense

[Birdman1971]

Thanks David . Really appreciate the assistance. Using the union had not crossed my mind ! 

Have a great day. 

[davidskaife]

No problem, would you mind marking it as an accepted solution to help others who may have the same query?