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.
Solved! Go to Solution.
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:
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_NAME
25,John,Smith
16,Michael,Jones
345,Donald,Trump
18,Hillary,Clinton
225,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.