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