how to join multiple tables in qlik view

[#1]

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 ?

[maxgro]

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

[#3]

Thanks

Could you give me more brief Example on these

[maxgro]

// 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;

// join C to (join B to A)

join (A)

load * resident C;

// 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

[#5]

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]

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

];

[#7]

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.

[#8]

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