4 Replies Latest reply: Feb 21, 2013 3:53 AM by C V RSS

    Populate missing data on Table1 from Table2

    C V

      Hello there,

       

      I have a Table1 with a list of basic values that belongs to a specific ClassID. And I have a Table 2 with a complete list of Items that belongs to every ClassID.

      I need to add to Table1 the missing items that are listed on Table2, considering also the typeID.

      The final result most be something like:

       

       

      TypeIDClassIDItemIDItemNameAmount
      110100A1000
      110200B1000
      110300C1000
      110400D2000
      110500E3000
      1201100FF100
      1201200GG200
      1201300HH

      300

      210400D2000
      210100A1000
      210200B1000
      210300C1000
      210500E3000

       

       

      I attach the Qlikview file.

      Thanks for any advice.

      Best regards,