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