Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
I have attached a small part of a CSV file that I am trying to load.
The challenging part is not only getting the data in a table format, but also each record has 2 rows.
How can I get this data into a table with only one row of data per record?
Sample data from file: (I added where I need the breaks)
Solved! Go to Solution.
Im sure there are better ways to go about this, but this is the first thing I came up with.
I used a record id divided by 2 to create paired ids, split out the first column and did a crosstab to group the two lines back together using concat.
That gave us one row per record with the record id in the first column and the rest of the data in the second. You can split it out from there however you feel is appropriate.
Actually, I overthought that. Just split out the first column and roll it up on that since its already paired ids.
