First column does not have a header and is a list of numbers. Other columns have headers. I would like to remove the first column.
If there is NOT a value in the first field on the first row - so e.g. your data looks something like this:
FIRST_NAME,LAST_NAME25,John,Smith16,Michael,Jones345,Donald,Trump18,Hillary,Clinton225,Elvis,Presley
...where you have some header fields and they are meant to refer to fields 2 thru X, then the attached workflow should work.
On your input you want to again indicate first row is NOT a header. And make the delimiter this:
\0
This tells Alteryx to bring the data in as a line of text, versus individual fields. This would get you up to the same point as the output of tool #1 in the attached workflow.
The logic of what it's then doing is:
Should work fine.
Is there also some value in that first field on the top row - or at least a comma there to mark where a field would be?
If so, here's my suggestion:
