This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am new to Alteryx and I am currently trying to parse data from one single field, and then use that data to populate the column headers and the columns. I was able to transform the data I need into rows. However, I can't parse it into columns and create a header for each column. I have tried using RegEx and the cross tab tools but it's not working. Any tips or advice on how to do it would be greatly appreciated.
Thank you very much for your time!
The data I need to parse is all in the DownloadData field.I was able to select the DownloadData and transpose it into columns. But how do I parse the columns headers and data from that one column?
I got to this point but I am not sure how to proceed from now. I am still having a hard time figuring the configuration of the cross tab tool to populate the headers from DownloadData. Any help would be greatly appreciated. Thank you very much.
There are two approaches you can take to parsing this, one where you parse into columns (and set the # of columns in the Text to Columns tool), and another where you parse into rows (which is more dynamic as you don't need to know the exact number of columns)
With either approach, start by parsing into rows on the "\n" delimiter (end of line). Then you can choose. My attached workflow shows both.
If you want to parse again into rows, you need 2 unique identifiers. One to say which row this should be (the crosstab tool will use this as the Grouping field) and one to say which column this should be (the crosstab tool will use this as the column headers field).
The RecordID tool for the Row unique ID needs to come right after the first Text to Columns tool, so you're keeping your rows together.
There are many ways to create that column identifier. I like the Tile tool, using Unique Value & grouping fields. This will count each row within each group.
After the crosstab, dynamic rename will pop the first row into headers. Choose "Take Field Names From First Row of Data"
Thank you very much @EstherB47! I used the first method and it is so easy to implement. I am still new to Alteryx and I am not fully familiarized with all tools yet. Thank you so much again for your valuable tips!