I would like my header to be my first row of data and my first row of data to be my header. This is for the final report export and am not sure if the Reporting nodes can handle this or another way?
Here is how my current data looks. (There are many more rows in the file)
AREA | H9 | H10 | H11 | H12 | Type_H9 | Type_H10 | Type_H11 | Type_H11 |
TEXT A | TEXT B | TEXT C | TEXT D | |||||
Anartica | CE | DE | DE | FG | 3 | 2 | 2 | 7 |
Here is how I want it to look as my final format.
TEXT A | TEXT B | TEXT C | TEXT D | |||||
AREA | H9 | H10 | H11 | H12 | Type_H9 | Type_H10 | Type_H11 | Type_H11 |
Anartica | CE | DE | DE | FG | 3 | 2 | 2 | 7 |
Thank you!
Solved! Go to Solution.
Nice, that was sneaky!
Hi @Dave_Mosk
If it solved your problem, please accept my answer as a solution to the topic.
Thanks!
So my data table looks like that in the middle of the workflow. Your solution inputs the data where the first row is not set to be a header. What would the solution be if the my data is mid workflow?