Qlik Community

New to Qlik Sense

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

Announcements
WE ARE LISTENING! New Navigation for Qlik Community, Sept. 26: TELL ME MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
ioannagr
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,
a.products
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
jonas_rezende
Specialist
Specialist

Hi, @ioannagr .

 

Please, upload  the script or the log.

Thanks,

Jonas Rezende.