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

[paulwini]

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

[HomesickSurfer]

Hi @paulwini 

Here's my solution. Isolate the 1st record(row), transpose, union, transpose in reverse order, re-union

Workflow package attached.  Export to C:\Temp to test.  Enjoy!

[mceleavey · Accepted solution]

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:

I hope this helps.

M.

[paulwini]

Incredible! Thank you both so much. Exactly what I needed.

[mceleavey]