Skip a column in upload file

[dfranko]

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

[echuong1]

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]

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]

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.

[dfranko]

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

I used the select tool.

[echuong1]

Fantastic!

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

[Anushavasu]

Hi Team, can somebody help me out  in this scenario ...from TXT file in Alteryx i wanted to do below things:

1. I want to skip few columns 

2.  in column 'A' i want to filter for few entries and delete

3. in column 'A' say for eg: i have XYZ and ABC names and i want to delete XYZ name and in column 'B' whatever we have for XYZ i want to paste same thing in column a