Field not found > error in where condition

[archire2102]

Hi,

Below is the screenshot of my code where Qlikview is throwing error of field not found for the operator '>'. I am trying to apply incremental load.

FROM

[..\Source Files\Dfiat-report-*.csv]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq, filters(

Replace(9, top, StrCnd(null))

)) where [Assessment last modified] > $(LastUpdatedDate);

Thanks in advance.

[archire2102]

Hi,

I observed that if there are multiple files with the name using report-*, then the incremental load will not work. So we should have only the latest file in the source folder.

[vishsaggi · Accepted solution]

Is this field  [Assessment last modified] coming from your csv file? May be try like

Look for any spaces in your field name just in case.

LOAD *

FROM 

[..\Source Files\Dfiat-report-*.csv]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq, filters(

Replace(9, top, StrCnd(null))

)) where "Assessment last modified" > '$(LastUpdatedDate)' ;

OR

LOAD *

WHERE [Assessment last modified] > $(LastUpdatedDate) ;

LOAD *

FROM 

[..\Source Files\Dfiat-report-*.csv]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq, filters(

Replace(9, top, StrCnd(null))

)) ;

[olivierrobin]

as there are many files, try to see which one is in error (see the log)

maybe the field is missing in one of the files

[archire2102]

Hi Vishwa,

Below code worked for me. The variable need to be in single quotes.

where "Assessment last modified" > '$(LastUpdatedDate)' ;

Thanks a lot.

[vishsaggi]

‌glad it worked