topic Re: Mimicking a Synthetic Table? in QlikView

Mimicking a Synthetic Table?

Fri, 08 Aug 2014 18:57:39 GMT

Forgive me if this is a no-brainer, but I'm fairly new to the development side of QV. Right now my application is running with one synthetic table linking three separate datasets. We have left the synthetic table in place because none of our fields are sufficiently unique/expansive to function as a perfect key, but between the four fields we have in the synthetic key, our application works. I learned in the developer course that one way to get around this is to recreate the synthetic table as a table of your own, but I forget how to do this, and my own messing around has only led to repeated system crashes. Could someone explain the steps to this (loading single fields? joining?)?

Thanks

Re: Mimicking a Synthetic Table?

marcus_sommer — Fri, 08 Aug 2014 19:19:50 GMT

Have a look here:

http://community.qlik.com/blogs/qlikviewdesignblog/2013/04/16/synthetic-keys

http://community.qlik.com/blogs/qlikviewdesignblog/2013/06/25/circular-references

http://community.qlik.com/blogs/qlikviewdesignblog/2013/10/29/clarity-vs-speed

- Marcus

Re: Mimicking a Synthetic Table?

Fri, 08 Aug 2014 20:04:03 GMT

Thanks Marcus - by the looks of that first link, my current synthetic key may be the best option we've got...