Bring in data on line 3 and use line 2 for column headings in Alteryx Cloud

[SeanAES]

I am transitioning some workflows to Alteryx Cloud from Alteryx Designer.   In Alteryx Designer it was easy to bring in data on Row 2 and then use row 3 as the column names.   I cannot find a way to do that in Alteryx Cloud.   I do not find that option in the data features for uploaded datasets.  It has infer header, which doesn't work at all.  I also have 50 + of these files and I would like to batch the process and bring in a specific sheet across all of them.  I don't see a way to do that either. 

[javier_rios]

Hi @SeanAES 

Yes, I totally agree with you. BUT there are ways to solve the issue. here is one. 

I copied your data into a TEXT Input tool

The idea is to add a RowID so you can separate the data vs the header in your case. Once you have the RowID, separate the data (rowId 2 and beyond), you will need to use a TRANSPOSE tool so you will have the column names in the Value Column. The next step is to use a CROSS TAB to  tool to recreate the new column names. Finally you use a DYNAMIC RENAME and voila! you have a solution.

See JSON attached. (I changed the extension to txt)

Hope this helps :)