topic Re: How join tow tables in QlikView

How join tow tables

Thu, 05 Feb 2015 11:08:43 GMT

Hi Friends,

I have two tables like this

Table1:

Load * inline

[

Acc value

2014 xxx

2014 yyy

2014 xxxx

];

Table2:

Load * Inline

[

Abc value

2014 xxx

2014 yyy

2014 8888

2015 xxxx

];

I want to separate data into 2014 and 2015 qvds with no duplicates and repetitions.

Thanks

Re: How join tow tables

alexandros17 — Thu, 05 Feb 2015 11:33:19 GMT

Try with

TableAll:

Load * inline

[

Acc value

2014 xxx

2014 yyy

2014 xxxx

];

Inner Join

Load * Inline

[

Abc value

2014 xxx

2014 yyy

2014 8888

2015 xxxx

];

Re: How join tow tables

Anonymous — Thu, 05 Feb 2015 11:39:14 GMT

you can join your table as required .. see example and also see the post.

Different Join Functions in Qlikview

Table1:

Load * inline

[

Acc value

2014 xxx

2014 yyy

2014 xxxx

];

left join(Table1)

Load * Inline

[

Abc value

2014 xxx

2014 yyy

2014 8888

2015 xxxx

];