Field Name Contains Data in Middle of Workflow: Push Field Name Row Down (not Input tool)

Hi Everyone,

I have an Alteryx workflow where the data in the field name contains data, and so I need the field names to be pushed down into the first row. I then need the field names to be F1, F2, etc. after this is accomplished. I know in my attached workflow I could easily change the input tool to select "First Row Contains Data", but in my use case the data is structured this way after the input tool. I therefore can't use this solution.

Initial Data Structure:

Desire Output:

Does anyone have any tips on how to accomplish this? Attached is an Excel file of the data and a sample Alteryx workflow.

Thank you,

Paul

FirstRowData.yxmd

SuperstoreInputxlsx.xlsx

Tips and Tricks

Best Practices

Transformation

Accepted answers

mceleavey

Hi @paulwini ,

My take on this:

The problem you have is that the rename will remove the column headers rather than move them down, so a quick pivot and a generation of the new required headers gives you both. You then just need to pivot back and union: