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) AREAH9H10H11H12Type_H9Type_H10Type_H11Type_H11 TEXT ATEXT BTEXT CTEXT D AnarticaCEDEDEFG3227 Here is how I want it to look as my final format. TEXT ATEXT BTEXT CTEXT D AREAH9H10H11H12Type_H9Type_H10Type_H11Type_H11AnarticaCEDEDEFG3227 Thank you!

How can I switch my first row of data with my header?

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!

Workflow

Reporting

Accepted answers

Felipe_Ribeir0

Hi @Dave_Mosk

Using this first part (inside of the container) is one way of doing this

How can I switch my first row of data with my header.yxmd

All comments

Felipe_Ribeir0

Hi @Dave_Mosk

One way of doing this

How can I switch my first row of data with my header.yxzp

Dave_Mosk

Nice, that was sneaky!

Felipe_Ribeir0

Hi @Dave_Mosk

If it solved your problem, please accept my answer as a solution to the topic.

Thanks!

Dave_Mosk

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?

Felipe_Ribeir0

Hi @Dave_Mosk

Using this first part (inside of the container) is one way of doing this

How can I switch my first row of data with my header.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15881

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703