I work with csvs that sometimes have errors in them. For example, they may have 3 columns, but some rows happen to have more columns in the data.
For example, my file could look something like this:
Col1, Col2, Col3
a, b, c
d, e, f
g, h, i, j
So my file will error on the 3rd row because it looks like it has 4 columns but the csv only has 3 columns. I don't have control over how the csv is created so I can't change this.
I come from a Python background but am transitioning to a team that uses Alteryx so I'm trying to figure out how to handle this situation in Alteryx. In Python, I currently have my program just create more columns than I need so it imports everything I can then filter to the problem rows and fix them.
My files have millions of rows (normally around 10 - 30 rows will be like I described and there can sometimes be several extra commas, not just one extra.
