6 Replies Latest reply on Jun 8, 2016 6:07 AM by Andrii Kabanets

    Import only selected columns from Excel data source - Desktop v8.3.7 and v9

    Praveen Athanki

      Hello all,

      I have Tableau Desktop v8.3.7 and v9. I am connecting to Excel data source containing 20 columns but I need to import only 8 columns into Tableau for viz development. I searched the forum and the solution suggested was to open the xls file as 'open as legacy connection' and then use custom SQL. But, for the versions of Desktop I have, I am not able to get the custom sql option. Could someone provide screenshot to help?

       

      If there is some other option to delete the columns after import, that should also be fine

       

      Any help is appreciated

       

      Thank you,

      Praveen