1 of 1 people found this helpful
You should open the Excel file 'Open with Legacy Connection' then only "New Custom SQL" option is available in the Connection window...
1.select Excel Workbook
2.Click on Open Drop down then select Open With Legacy Connection
SQl Syntax for Excel Files..
Hiding columns does not help because Tableau imports all the unnecessary data that is not required though not displayed
I tried this option in Tableau v9 exactly as you have described but 'New Custom SQL' option does not appear. Any idea what could be the reason?
Yes, it works provided the steps are followed exactly that is
Connect to Data -> Select the xls file -> Choose 'open as legacy connection'
Thank you Babu
Hi V Babu,
Thank you for good explanation of this issue.
I also need to take only 4 columns from my 52 columns table.
And I have to say - this SQL decision correct but not in "easy drag&drop" Tableau concept and I face with some error message concerning connection with the file - it doesn't work. In this way it is easier to delete other columns in xlsx copy but in this case we will be unable to work with updated data later...
Do you know the link for detailed explanation of this option in Help or knowledge base?