topic Merge two tables in QlikView

Merge two tables

Anonymous — Sun, 25 Sep 2016 06:16:45 GMT

Hi All,

I have two tables say Tab1 and Tab2 and I want result as Tab3. What is the most efficient way to do it on large data set.

Tab1:

Date Type Amount

1/31/12 A 0

2/29/12 A 0

3/31/12 A 0

1/31/12 B 0

2/29/12 B 0

3/31/12 B 0

Tab2:

Date Type Amount

1/31/12 A 10

2/29/12 A 20

2/29/12 B 50

Tab3(Result Table):

Date Type Amount

1/31/12 A 10

2/29/12 A 20

3/31/12 A 0

1/31/12 B 0

2/29/12 B 50

3/31/12 B 0

Thanks in advance..

BR,

SAK