Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Direct Tables are not allowe in Synthetic Keys or Loops

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?)

Tags (1)