Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I read some materials about syntetic keys, but I still have troubles to understand them correctly. Some articles say they are ok (in some cases) and some says you should avoid them completly.
For example I have this data schema:
I have 3 main tables:
When I use field "User_account_login" in Customers and Invoices it's ok and load script run's normally (but with syntetic keys). But when I add "User_account_login" to Active services it's stuck and load don't work. But for example when I use User_account_login as "%Key" for every table it goes ok. It's strange for me.
Is there way how to solve this Synthetic keys when all 3 tables have same field "User_account_login" and "country_name"?
Thanks @miskinmaz . It took me some time but after reading this article http://www.learnallbi.com/link-table-in-qlikview/ a I was able to solve it.