Move the field name 2 rows down

[bshereme]

Here is how my data looks:

total_sales	GL account
500	[Null]
500	[Null]
5	255252
54	255251
etc	etc

(2 rows totaling 500 each from a different flow)

Desired outcome, which basically requires to move the field names 2 rows down while keeping everything else the same.

500	[Null]
500	[Null]
total_sales	GL account
5	255252
etc	etc

[geraldo]

@bshereme 

To meet this requirement, the columns will have to be non-numeric strings

[bshereme]

@geraldo that's what I'm realizing. Perhaps I can try something with multi-field row to convert to a number if possible? I know Alteryx doesn't support 2 data types per column.

[Yoshiro_Fujimori]

Hi @bshereme ,

Here is one way of doing this.

Workflow

The idea is to pick each rows as a chunk and Union the chunks in the desired order.

Output

[bshereme]

Once you export this to xlsx you will see all those numbers being stored as text, so while this accomplishes the question at hand it shows more issues later down the road