topic Re: Join tables saved as QVD in QlikView

Join tables saved as QVD

Anonymous — Sun, 08 Jan 2017 09:34:20 GMT

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

Re: Join tables saved as QVD

Anonymous — Mon, 09 Jan 2017 01:26:37 GMT

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;

Re: Join tables saved as QVD

Anonymous — Mon, 09 Jan 2017 06:00:26 GMT

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!

Re: Join tables saved as QVD

stabben23 — Mon, 09 Jan 2017 07:16:27 GMT

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;