9 Replies Latest reply on Sep 17, 2013 12:51 PM by michael.wu

    Possible to lookup one record in another data source and exclude?


      I'm trying to replicate the vlookup feature in Tableau. I have multipe data sources with serial #s of products. I'm trying to reconcile them. One is the "master" and is supposed to have a record of everything we own but is not always correct. Another has serial #s of products returned to the vendor so those should not be counted in our master. In both, the column contains a serial #. How can can I exclude a count of any items on the master that also show up in the returns spreadsheet. I tried to do a IF THEN statement but it keeps saying I can't use <> or any other function, with aggregate and non-aggregate values. But the thing is, they are both the same.