Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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
Thanks
Could you give me more brief Example on these
// 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;
Combining tables with Join and Keep ‒ QlikView
Understanding Join, Keep and Concatenate
http://www.qlikfix.com/2011/02/07/merging-tables-the-join-prefix/
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.
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
];
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.
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