Selecting Columns on Excel Data Import

Hi All,

First time post, I've looked through a lot of threads and couldn't find the answer.

I have an Excel Workbook that I'm trying to Input data from, but I only want about 6 columns of the 80 columns that have data.

I've seen where I can select a range of data, but I don't want to pull in all the columns between G and FX. Is there anyway I can call out in the SQL which columns to import?

Any help would be appreciated!

Input

Accepted answers

JoshKushner

You can do this in the input tool or with the select tool after reading in all 80 columns.

Input Tool:

When reading an excel doc you can modify the SQL. Press the '...' in the 'Table or Query' section. Then add the range you want (in this case 'A:F') after the '$' of the sheet name but before the apostrophe. This will only take in the first 6 columns.

sql edit.PNG

Select Tool:

Make sure you deselect the '*Unknown' field to only take in the columns you want. You can deselect all in the options menu then select the columns you want.

sonyakasenkramer

And...I figured it out. Name the range in Excel, then save the file. Once you do that, the "Select a named range" radio button will be available. It does mean that all of your columns need to be in a contiguous range though. (Or I suppose you could have multiple inputs that you then join)

All comments

JoshKushner

You can do this in the input tool or with the select tool after reading in all 80 columns.

Input Tool:

sql edit.PNG

Select Tool:

Make sure you deselect the '*Unknown' field to only take in the columns you want. You can deselect all in the options menu then select the columns you want.

thelegazy

Thank you so much!!

MPohlers

Is there a way to do this in Alteryx 2018.2? Neither the excel input nor the legaxy excel input allow my to define a query.

fiorano

Hi, can we also define which row to import from? I need to import columns A:AH and my header row is row 3.....

Thanks

Fiorano

Anand_Parekar

The input window to enter query is only displayed based on the type of file ( for eg. for data base), it doesnt show query window for .xls or .xlsx files inputs.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703