Query related to data model

[rsdhavle]

I am getting data from two tables. One contains current cube values and other has previous cube. Both has same columns as A, B , C.

When i run script as qlikview behaves it will automatically join tables on all the 3 columns. But its not displaying values when Column C is missing on some values in previous cube.

For modelling it properly should i use composite key or i should use some Join?

[sunilkumarqv]

use NoConcatenate statement in script in middle of the table

Exp:

TabA:

A

B

C

From datasoure...;

NoConcatenate

TabB:

A

B

C

From datasoure...;

[#3]

You can also use, left keep or right keep or inner keep based on your requirement, just replace join by keep to avoid concatenation

[rsdhavle]

Thanks..just one thing addition to it..lets say i want to join these two tables on C column then what to be done?

I don't need join on other two columns

[#5]

Just rename these columns in of the tables by using as

[sunilkumarqv]

Try like this Exp:

TabA:

A

B

C

From datasoure...;

Concatenate(C)

TabB:

A

B

C

From datasoure...;