5 Replies Latest reply: Aug 18, 2014 4:18 AM by Enrique Colomer RSS

    Combination of 2 fields to link 2 tables


      Hi all,

      I am trying to use a combination of 2 fields to link 2 tables.

       

      table 1:

      Product codeBatch numberreceived date
      1A01/01/2013
      1B01/02/2013
      2A01/06/2013
      2C01/06/2013
      3B01/03/2014

       

      Table 2:

      Product codeBatch NumberDispatch date
      1A01/12/2012
      1B01/01/2013
      2A01/04/2013
      2C01/04/2013
      2D18/08/2014
      3B01/01/2013

       

      In excel I would use a concatenate function between Product code and batch number (1A, 1B...) and a lookup to have visibility on disaptch date and received date. I believe the logic in qlikview is a little different

       

      Can someone please help me with this?

       

      Thank you so much in advance