6 Replies Latest reply: Jan 29, 2016 11:12 AM by Ryan Heacock RSS

    How to Remove Synthetic Key

    Ryan Heacock

      I have two DW tables, both very similar as far as the data goes, one is for Shipped orders, one is Backlog.  They do not link together in any way, but have 30 or 40 columns that are the same name and I would like to keep it that way to make it easier for the users building visualizations.  Is there a command I can use to force Sense to NOT create a synthetic key between these two tables with a massive synthetic key?  Everything I've read leads me to believe I need to rename nearly every column in one of these tables, just so Qlik won't automatically create the key.

       

      Also, I'm currently running Qlik Sense Desktop, waiting to get Enterprise installed.  Maybe this isn't an issue with Enterprise?

       

      Thanks for any help.