4 Replies Latest reply: Jan 19, 2018 1:37 PM by Martin Pohl RSS

    Qlik Sense with 2 left joins

    Paul Barrett

      Hello, 

       

      I have three sets of data all with the dimension 'Reference Number',   all the files contain some reference numbers which are the same and some different ones, each with other dimensions. 

       

      I need to load the first file then left join the two other sets of data but limiting the 'Reference numbers' in the first set of data.

       

      Example

      Reference NumberItem Number
      1A
      2B
      3C

       

      Reference NumberPart Number
      1D
      2E
      4F

       

      Reference NumberUnit Number
      2G
      3H
      4I

       

      Required Result

       

      Reference NumberItem NumberPart NumberUnit Number
      1AD
      2BEG
      3CH

       

      Please Help