Discussion Board for collaboration on QlikView Scripting.
I want to join two tables which I previous saved on my disk as QVD.
To simplify and try this I created 2 Inline tables.
What I want:
What I do:
What I get:
Is there a way to do the same as in the first snippet for QVD-Files?
This worked for me. You need to drop your resident tables. But also the load * resident needs to be a noconcatenate load.
load * inline [
noconcatenate load * resident Table1;
inner join load * resident Table2;
drop tables Table1, Table2;
View solution in original post
Table1: LOAD * INLINE [ A, B 1, aa 2, cc 3, ee ]; inner Join(Table1) LOAD * INLINE [ A, C 1, xx 4, yy ];
Hopefully this helps!
Hi, add follow script, Noconcatenate because qlikview will "autoconcatenate" the tables. You also need to drop Table1 and Table2.
Table1: LOAD * INLINE [ A, B 1, aa 2, cc 3, ee ]; Table2: LOAD * INLINE [ A, C 1, xx 4, yy ]; NoConcatenate Vtable: Load * resident Table1; inner join Load * resident Table2; drop tables Table1, Table2;