Move the field name 2 rows down

Question

Here is how my data looks:

total_salesGL account500[Null]500[Null]525525254255251etcetc

(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_salesGL account5255252etcetc

bshereme · Answer

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

Yoshiro_Fujimori · Answer

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

TwoRowsDown.yxzp

bshereme · Answer

@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.