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.
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 :)