0 Replies Latest reply: Aug 10, 2016 10:03 AM by Dawid Nawrot RSS

    Direct Tables are not allowe in Synthetic Keys or Loops

    Dawid Nawrot

      I have two simple Direct Queries in my Qlik Sense data editor but when I run it I am getting:

       

      Direct Tables are not allowed in Synthetic Keys or Loops

       

      has anybody got any information about what it means?

       

      All I have is:

       

      <alias>:

      LIB CONNECT TO '<connection>';

      DIRECT QUERY

      DIMENSION

         customer_name,

         customer_id,

         visits,

         sales

      FROM agg

          join customers on customers.id = agg.customer_id;

       

      <alias>:

      LIB CONNECT TO '<connection>';

      DIRECT QUERY

      DIMENSION

         customer_name,

         customer_id

      FROM customers;

       

       

      I'm doing this because when I use customer_name from the first load (which works fine) it tells me there are too many of them (thought the engine would take only unique values?)