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 trying to produce a .csv output file that contains 5 different types of records. Each record type contains a different number of fields, and the data in them is different. Effectively it's 5 different tables joined on to each other.
I can produce the data, but when I output it to a .csv Alteryx pads the shorter records with additional commas to match the number of fields on the longest record type. To add further complexity, one of the record types needs to have some empty fields at the end.
Is there a way to create a single CSV file with different numbers of fields in it for each row?
See below for the output I'm producing, and what I want to produce.