This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
You can do this in the input tool or with the select tool after reading in all 80 columns.
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.
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.
Hi Is there a way to refer to the columns by name? I know I can read all columns then use a select tool, but was wondering if selecting individual columns would speed it up. The file loads fine if I don't try individual columns. Thanks Jakub