5 Replies Latest reply: Mar 18, 2015 5:50 AM by Ralf Narfeldt RSS

    Need to create a new ID for a group of products?

      My data has a Transaction_Id (Trx_Id) that can have 1 to 3 Product Types (A,B,C) called a “bundle”.   Currently in my data there is no way to “group” or identify these Products as a bundle.  For example, if I want to filter-out any transaction that has product type A, I can exclude that product, but it doesn’t exclude the entire transaction…it leaves the transaction in the table because B and C are still there.  Ideally, I want to filter-out any “bundle” that contains product type A.  Does that make sense?  Is there some way in the script to create some sort of Bundle_ID which will allow me to do this?

       

      Thanks!