Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to join multiple tables in qlik view

Hi Friends,

I have a Query

1) Is it possible to join multiple tables in Qlikview ?

2) Can we store entire thing into Qvd?


Ex :- I have 3 tables like

A>>>>>>>>>>>>>>>>B>>>>>>>>>>>>>>>>>>C


how to we join these 3 tables in qlik view ?





7 Replies
maxgro
MVP
MVP

you need 3 step

load the A table

load B table and join with A

load C table and join with A

you can store the result of the joins (A join B join C) in a qvd

Not applicable
Author

Thanks

Could you give me more brief Example on these

maxgro
MVP
MVP

// 3 tables: A B C

A:

load * inline [

f1, f2

a,1

b,2

c,3

];

B:

load * inline [

f2, f3

1,11

2,22

];

C:

load * inline [

f3, f4

11,oneone

];

// join B to A

join (A)

load * resident B;

1.png

// join C to (join B to A)

join (A)

load * resident C;

1.png

// now you have 3 tables :

// A join B join C in table A

// B table

// C table

// if you only want the 3 tables joined, drop B and C

DROP Table B;

DROP table C;

Joins and Lookups

Combining tables with Join and Keep ‒ QlikView

Understanding Join, Keep and Concatenate

http://www.qlikfix.com/2011/02/07/merging-tables-the-join-prefix/

QlikView Addict: Explaining Joins

Not applicable
Author

Hi Bro,

Thanks for your information need to use resident to join another table to A.?

if there is no common key column between two tables how we can join please let me know ASAP.?

thanks

Krish.

maxgro
MVP
MVP

Thanks for your information need to use resident to join another table to A.?

No, you can join from every source (qvd, txt, database, inline, etc)

if there is no common key column between two tables how we can join please let me know ASAP.?

A:

load * inline [

f1, f2

a,1

b,2

];

join (A)

load * inline [

f3, f4

a,1

b,2

];

1.png

Not applicable
Author

If the tables are almost exactly similar, use concatenate before you load them in the Data Loader.  Try to use the concatenate "file" in the data loader meaning you have to modify it before it't's reloaded.  If you use really large data files it will take a few minutes but works,  Look in to Cross-tables too. There an excellent article out there.  Enjoy,

Tom

Not sure about access restrictions for doing it with actual databases but using flat flies it seems to work fine.

Not applicable
Author

I came to this post because I had the same question.

By now, the issue is likely resolved, but for future Qlik Community members needing assistance

It looks like the tables could be linked through a process that looks like this:

Good luck and happy tabling