Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Skip a column in upload file

dfranko
5 - Atom

How to skip a column of data in the upload process?

 

I have let's saw 30 columns of data, and I was to exclude to of the columns?

 

Any advice is greatly appreciated.

 

Thank you

 

David

5 REPLIES 5
echuong1
Alteryx Alumni (Retired)

If you are uploading from a file, this is not possible. You'd have to import all of the data, and then use a Select after to remove the column.

 

Alternatively if you are importing from a database, you can specify the columns you'd like in the select statement.

 

Hope this helps!

dfranko
5 - Atom

I have uploaded all 30 columns.  What tool do I use to separate out the two columns I do not want to use on a go forward basis?

 

Thank you

 

David

echuong1
Alteryx Alumni (Retired)

Use a Select tool.

 

In the example attached I imported 15 fields. In the select tool, I unchecked the ones I did not need, so I only have 3.

 

echuong1_0-1606250886236.png

 

dfranko
5 - Atom

I found out where to remove the columns from my data.

 

I used the select tool.

 

echuong1
Alteryx Alumni (Retired)

Fantastic!

 

Please mark this thread as solved so others can find answers more easily. Thanks!

Labels