5 Replies Latest reply: Apr 17, 2013 4:14 AM by Sergey Varbanov RSS

    Data Intersection

      Hi,

       

      I have two tables: transactions and platform. Here's a sample:

       

      transactions:

      LOAD * INLINE [

      transaction, site, platform

      1, 1, 0

      2, 1, 1

      3, 1, 1

      4, 2, 0

      5, 2, 0

      6, 2, 0

      7, 3, 1

      8, 3, 0

      ;

       

      platform:

      LOAD * INLINE [

      platform, platform_name

      0, new

      1, old

      ;

       

      I would like to limit the transactions table to only include sites which have transactions on both platforms , 0 and 1. In this case, I would only import data for sites 1 adn 3, since site 2 only has sales on plaform 0. Does anyone know how I can specify this in my import script?

       

      Thanks in advance for the help, it is very appreciated. I've attached a qvw with the sample data shown above.

       

      Best,

       

      Matt