2 Replies Latest reply: Sep 25, 2014 8:16 AM by Geert Geladé RSS

    create table with left join along with multiple dimension

    vikas mahajan

      I have table A and I want to load this in Qlikview with left join or any join

       

      Item_CodeDimension Set IDLot No_Posting DateEntry_TypeDoc_NumLocation_CodeInventory_Post_Grp_CodeDept_CodeDiv_Code
      LC000022332182NULL22/07/20090RD/EX/GRN/0910/00011TL-RT0001TOOLS-LABNULLNULL
      LC000022332182NULL22/07/20090RD/EX/GRN/0910/00011TL-RT0001TOOLS-LABNULLNULL

       

      and Table B

       

      Dimension Set IDDimension CodeDimension Value CodeDimension Value IDName
      32182BSEG1110221Formulation
      32182ALOC130369R&D Rabale
      32182DEPT2320920R&D - FDF - AMD
      32182DIV1120233FDF - Common

      I want to update Dimensions in table A  Dept_Code and Div_code   where Dimension  Set ID is common key for this and

      base on where condition Dimesion code= 'DIV'  I want to update div and dept while loading in Qlikview.

       

      I have attached excel sheet also , Urgent help required.

       

      Vikas