Data modeling and auto join(Synthetic keys)

[#1]

Hi All,

I am facing same problem with data model. I have 4-5 de-normalized table. each are with 9-10 common different fields.

So what is the problem . Qlikview is taking auto join b/w them. So, my data is not coming properly.

it is creating multiple synthetic keys.

Please,Give me a solution.

ASAP.

Thanks.

[#2]

Yes. I need different values from several tables.

that's why concatenate may not work.