Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

How to merge different columns into single table

I have 4 tables TABLEA, TABLEB, TABLEC, TABLED.

TABLE A            TABLE B              TABLE C                      TABLE D

S.NO SALES      S.NO DATE          S.NO PRODUCTS        S.NO LOCATION

1        253              1    01/03/18        1        LENOVO            1        HYD

2        125              2    02/03/18        2        LG                      2        USA

3         326            3    05/03/18        3        SONY                  3        CHINA

4         555            4    09/04/18        4        TATA                    4        JAPAN

5         125            5    10/04/18        5        BPL                      5        UK

                              6    15/04/18        6       CASIO                  6        ITALY

                                                          7        HP


I want OUTPUT like this below:


S.NO  SALES  DATE        PRODUCTS   LOCATION

1          253       01/03/18    LENOVO        HYD

2          125       02/03/18    LG                  USA

3          326       05/03/18    SONY             CHINA

4          555       09/04/18    TATA               JAPAN

5          125       10/04/18     BPL                UK

1 Solution

Accepted Solutions
Highlighted

Left Join them all into a single table

Table:

LOAD S.NO,

     SALES

FROM TABLE A;

Left Join (Table)

LOAD S.NO,

     DATE

FROM TABLE B;

Left Join (Table)

LOAD S.NO,

     PRODUCTS

FROM TABLE C;

Left Join (Table)

LOAD S.NO,

     LOCATION

FROM TABLE D;

View solution in original post

1 Reply
Highlighted

Left Join them all into a single table

Table:

LOAD S.NO,

     SALES

FROM TABLE A;

Left Join (Table)

LOAD S.NO,

     DATE

FROM TABLE B;

Left Join (Table)

LOAD S.NO,

     PRODUCTS

FROM TABLE C;

Left Join (Table)

LOAD S.NO,

     LOCATION

FROM TABLE D;

View solution in original post