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.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
I have a issue with data in a CSV input, where certain fields have not been split due to the irregular data in in it.
Only 1 field is causing the misalignment of data for the many rows that have the irregular data, not all rows are affected.
Note: The data that is being input from CSV and is already being split by Alteryx via "\0" delimiter as i was getting "Too many fields in Record x", and also is going through a StripQuotes Multi-Field formula (Screenshot attached).
The issue is more to do with some of the data in the input that i am trying to accommodate.