Csv file with varying number of columns in each row

[heidi_andrew]

my csv file has several rows for each person on the file. The specific rows have different number of columns in each row. CSV file reader is having trouble with it. Is this impossible to read for this snap?

[koryknick]

If you can attach a copy of the data in present and desired states, that would be very helpful.

[heidi_andrew]

There is a file attached to the ticket way early. That was the beginning state. I was able to pull that apart by rows, apply my fix and now all of the EEID rows are in one file, all of the OFFR rows are in one file, etc. Now i need to put them all back together like the one in the ticket.

[koryknick]

Can you provide more detail of what you’re doing now and what the current issue is, and perhaps why the solution provided earlier wasn’t implemented?

Also - since this topic already has a listed solution, you might want to open a new post with your current challenge. Make sure you provide the details of your input, the pipeline you’ve implemented so far, an example of the output you have, and the desired output.