Transform Headers into rows - cross tab

[sneha_bhiwagade1]

Hi Team,

I have the input dataset in below format and need the desired output.

Input:- 

name	abc	age	10
roll no	1	sub	eng

Output:-

name	age	roll no	sub
abc	10	1	eng

Could you please help me on the same :)

Many Thanks in advance!!

[gawa · Accepted solution]

@sneha_bhiwagade1 

If your data always have the same schema, it's worth of trying the Arrange tool.

By doing so, input data will be piled vertically so the Cross-tab tool can be directly applied.

[Raj · Accepted solution]

@sneha_bhiwagade1 if you are having the data always in same format then 
arrange tool will work best else there will be a requirement on the new logic.

[sneha_bhiwagade1]

thanks @gawa for the solution

but my input file header is starting from name. I don't have the field1 as header. how to get that

thanks in advance

name	abc	age	10
roll no	1	sub	eng

[gawa · Accepted solution]

@sneha_bhiwagade1 

I think your input data is MS Excel or CSV then you can utilize option of "First Row Contains Data" and/or "Start Data Import Line" in the Input tool to adjust header. Good luck!

[Raj]

@sneha_bhiwagade1 
find the workflow attached
mark done if solved.