How do I remove synthetic keys?

[Anonymous]

Hi all,

I'm having trouble building my table relationship in Qlikview.  I have four tables: CSA, Template, Orders, and Customers.  A customer can have a CSA or a Template (not both).  I sense that this may be causing some redundancy but I'm not sure how to remove it.  Any advice?  I've attached an image of my relationships to make it easier to see.

Cheers

[awhitfield]

Not only synthetic keys, but circular references too!

[awhitfield · Accepted solution]

Hi Henry,

check these out:

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/synthetic-keys.htm

and

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/LoadData/understand-circular-ref...

HTH  Andy

[Anonymous]

Cheers, had a read through, just need to change my data model.