Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

WE ARE LISTENING! New Navigation for Qlik Community, Sept. 26: TELL ME MORE
Showing results for 
Search instead for 
Did you mean: 
Creator III
Creator III

Problem in SQL select

Hello everyone. 

I need your help. 

I have a table  (let's call it b) for which I created firstly a qvd, then I added incremental load, so in the where part of the table there is:

where updated >'$(Last_Update_Date)');


Later ,  a table that I made the qvd for, is  a .

Tables a and b share the field id .

For table a, I wanted to keep only the  latest id's that can be found in b, then concatenate with the rest,

with this  SQL select statement:

SQL select a.id as id,
from products a
inner join  questionnaire b
on a.id=b.id where  b.updated >'$(Last_Update_Date)');



The debugger shows field id can't be found.


Can you please tell me what is wrong?


1 Reply

Hi, @ioannagr .


Please, upload  the script or the log.


Jonas Rezende.