Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Join tables saved as QVD

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:

WhatIWant.png

What I do:

WhatIDo.png

What I get:

     WhatIGet.png

Is there a way to do the same as in the first snippet for QVD-Files?

BR,

Emanuel

1 Solution

Accepted Solutions
Highlighted
Contributor III
Contributor III

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;

View solution in original post

3 Replies
Highlighted
Contributor III
Contributor III

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;

View solution in original post

Highlighted
Specialist
Specialist

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!

Highlighted
Master
Master

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;