4 Replies Latest reply: Sep 27, 2017 7:08 PM by Amuktha Chakilam RSS

    Join and update tables in QlikSense

    Amuktha Chakilam

      Hi,

       

      I have two tables. Please help me in updating the field values while joining them

       

      A:

      load * inline[

      id, field1, field2

      1,0,0

      2,0,0

      3,0,0

      4,0,0

      5,1,0

      ];

       

      B:

      load * inline[

      id, field1, field2

      1,1,0

      2,1,1

      3,0,1

      6,1,0

      ];

       

      Question: Update table A by checking if the `id` from A is present in B or not(similar to left join). If present in B, update the field1 and field2 values of that id in A by picking its corresponding values from table B

       

       

      Required Output is (modify table A as:)

      id, field1, field2

      1,1,0

      2,1,1

      3,0,1

      4,0,0

      5,1,0

       

      I appreciate any help with this.

       

      Thanks,

      Amuktha