I am not able resolve synthetic key in the data model

[#1]

I am following a book "Qlikview Essentials" which includes Adventure Works data model. But I am not able to resolve the synthetic keys. Can anybody please help me in resolving the same.

[MK9885]

Synthetic keys can be avoided but I cannot suggest until I see the data.

From those Images I can say Concatenate Employee table and Orders Table as they have few fields in common.

Can you upload the sample data with your sample qvw?

[johnw]

Your orders table looks broken. It probably shouldn't have anything from the synthetic key on it except for the employee ID. Somewhere in the script you're probably joining all the employee information onto the orders table.

[#4]

Yes. Thanks. I have commented "employees let join (orders)". But now data model looks like attached one.

[johnw · Accepted solution]

OK, so now you're joining the employee information onto the sales person table. Don't do that either.

[#6]

Thanks John. I used concatenate operator between Employees and SalesPerson tables. Which is not written in the book it seems.

[#7]

Thanks. Solved it.