topic Re: Three identical tables in QlikView

Three identical tables

qlikviewwizard — Tue, 11 Aug 2015 05:54:05 GMT

Hi All,I have 3 tables with the same table structure.Which is the best way to combine these 3 tables?

Concatenate/join/ not mentioning either?

Please suggest. Thanks in advance.

Table1:

Select C1,C2,C3 from Table1

Table2:

Select C1,C2,C3 from Table2

Table3:

Select C1,C2,C3 from Table3

Re: Three identical tables

sunny_talwar — Tue, 11 Aug 2015 05:56:24 GMT

I would think Concatenating them would make sense.

Re: Three identical tables

jagan — Tue, 11 Aug 2015 06:07:26 GMT

Hi,

You can concatenate the 3 tables, since all having the same columns so Concatenate is the best option. If you want a flag to identify the source of each you can add the flag like below

Data:

Select C1,C2,C3, 'Table1' AS Source from Table1.

Concatenate(Data)

Select C1,C2,C3, 'Table2' AS Source from Table2.

Concatenate(Data)

Select C1,C2,C3, 'Table3' AS Source from Table3.

Hope this helps you.

Regards,

Jagan.

Re: Three identical tables

jagan — Tue, 11 Aug 2015 06:09:03 GMT

What data is there in columns C1, C2 & C3 if anyone is a measure like Sales then Concatenate it without further thinking.

If you join ultimately you will get only 3 columns by reducing the Row Count.

Regards,

Jagan.

Re: Three identical tables

qlikviewwizard — Tue, 11 Aug 2015 06:10:24 GMT

Thank you both of you.

Re: Three identical tables

Tue, 11 Aug 2015 06:34:44 GMT

concatenate is best option ...

Re: Three identical tables

jagan — Tue, 11 Aug 2015 06:46:50 GMT

Check below links, hope it helps you.

Merging Data from Multiple Sources

Understanding Join, Keep and Concatenate

Regards,

jagan.

Re: Three identical tables

qlikviewwizard — Tue, 11 Aug 2015 06:57:14 GMT

Thank you so much Jagan.