Join tables saved as QVD

[Anonymous]

Hey folks,

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?

BR,

Emanuel

[Anonymous · Accepted solution]

This worked for me. You need to drop your resident tables. But also the load * resident needs to be a noconcatenate load.

Table1:

load * inline [

  A, B

  1, aa

  2, cc

  3, ee

];

Table2:

load * inline [

  A, C

  1, xx

  4, yy

];

VTable:

noconcatenate load * resident Table1;

inner join load * resident Table2;

drop tables Table1, Table2;

[Anonymous]

Hi,

Try,

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!

[stabben23]

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;