7 Replies Latest reply: Aug 21, 2017 5:15 AM by Erdal Cücen RSS

    Qlikview Load Multiple Excel Sheets (Concatenate & Join tables)

    Erdal Cücen

      Hi, i have a simple problem. I will join 4 excel tables.

      The first 3 tables are the same in the structure. The fourth table have some more information about the customer

       

       

      1. TABLE
      CUSTOMER_IDCUSTOMERYEARSalesAmount
      1AAAA20151.000
      2BBBB20152.000
      3CCCC20153.000
      2. TABLE
      CUSTOMER_IDCUSTOMERYEARSalesAmount
      1AAAA20165.000
      2BBBB20166.000
      3CCCC20167.000
      4DDDD20168.000
      3. TABLE
      CUSTOMER_IDCUSTOMERYEARSalesAmount
      1AAAA20176.000
      2BBBB20177.000
      3CCCC20178.000
      4DDDD20179.000
      5EEEE201710.000
      4. TABLE
      CUSTOMER_IDCUSTOMERCOUNTRY
      1AAAAUSA
      2BBBBCHINA
      3CCCCGERMANY
      4DDDDMEXICO
      5EEEE

      CANADA

       

       

      So my question is how can i merge this four tables to one table in Qlikview.

       

      I think it should be solved by concatenate and/or joining anyway however.

       

      Thank you in advance.

      Erdal