topic Re: Bring in data on line 3 and use line 2 for column headings in Alteryx Cloud in Alteryx Designer Cloud Discussions

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

SeanAES — Tue, 18 Jul 2023 02:19:52 GMT

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.

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

javier_rios — Thu, 23 May 2024 16:43:08 GMT

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