Hello! I'm having trouble working with the following dataset. As you can see, the data are separated by commas and a new record starts on a new row. However, the last field from any record is not followed by a comma between that field and the first field on the next record.
Can anyone give me tips on how to neatly transform this into a table with columns and rows? Ideally after I figure out how to parse it out, I will not even go the route of reading from a CSV. The CSV was an intermediate step, but I was originally reading from a webpage and only put a .cvs step in there because I thought it might allow me additional flexibility in parsing the data.
Thanks! Kurt
Solved! Go to Solution.
Hi @kurtwz ,
Take a look at the attached example and let me know if this works for you.
Best,
Fernando Vizcaino
Hi @kurtwz,
I wouldn't attempt to solve this in Alteryx, I'd quickly fix the input.
Remove the first row "DownloadData" and the first two characters in the second line as well as the last character at the end of the file and it's a perfect csv file that works with default settings in Alteryx.
Regards
Alex
Thanks very much for the support, Fernando!
Worked like a charm and you win the speediness race! That was too easy for you, though! 😛 Thank you for the help Greg!