9 Replies Latest reply: Jan 10, 2013 11:43 PM by Khadeer Shaik RSS

    Synthetic tables

    Cristina Fiacconi

      Hello everyone,

       

      I am joining tables from two different databases (one in SQL, one in Jade)

      I'm trying to design a summary of transaction by employee code (common in both dbs), and transaction type (I've created a conversion table for that), and by date grouped into months.

       

      This alllowes me to compare transactions in both db at the same time, so that if I change criteria on a list box, it actually filters data in both dbases.

      My summary seems to work but if I check the links, it looks like QlikView has created Synthetic keys, which I believe should be avoided at all cost (Im new to QV).

       

      Can I avoid this problem, still allowing a user to only enter criteria once?

       

      Thanks for your time