1 Reply Latest reply on Jan 16, 2017 4:06 PM by diego.medrano

    Left Excluding Join of 2 Excel worksheets Tableau 10.1.1

    Judy Abbruzzesi

      I have a large Excel worksheet (10,000+ rows, 170 columns.)  I have a second, smaller Excel worksheet containing records that I need to exclude from the larger worksheet.  I would like to be able to create a Left Excluding Join to remove the intersection of the the two files and retain only unique records from the larger file.  The larger worksheet is static, only changing when records need to be removed using the smaller file.  I remember something about an 'Exclude' option mentioned at TC16 but I cannot find it anywhere!

       

      Thank you in advance!