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.
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