How join tow tables

[#1]

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

[alexandros17]

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

];

[Anonymous]

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

];