Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Master II
Master II

Three identical tables

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

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

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.

View solution in original post

7 Replies

I would think Concatenating them would make sense.

MVP & Luminary
MVP & Luminary

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.

View solution in original post

MVP & Luminary
MVP & Luminary

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.

Master II
Master II

Thank you both of you.

Not applicable

concatenate is best option ...

MVP & Luminary
MVP & Luminary

Check below links, hope it helps you.

Merging Data from Multiple Sources

Understanding Join, Keep and Concatenate

Regards,

jagan.

Master II
Master II

Thank you so much Jagan.