2 Replies Latest reply: Aug 11, 2011 2:48 PM by Justin Kelly RSS

    Exclude Multiple Records in Script

    Justin Kelly

      I have a problem that doesn't seem too complicated but I just can't figure it out. I have two Excel files, one with all of my product data and one that is just a list of products that I need to exclude from the data. Example:

       

      DATA_TABLE:

      Product#, Name, Inventory

      1001, A, 500

      1002, B, 600

      1003, C, 200

      1004, D, 700

      1005, E, 900

      1006, F, 100

      1007, G, 200

       

      EXCLUSIONS_TABLE:

      Product#

      1001

      1004

      1005

       

       

      From what I've searched for on the boards, WHERE NOT looks like it is the solution for excluding a few items in the script, but I have a lot more than just a few exclusions and they may change from week to week.

       

      Any help would be greatly appreciated.

       

      Thanks!

       

      -- Justin