topic Re: Field not found > error in where condition in QlikView

Field not found > error in where condition

archire2102 — Wed, 28 Mar 2018 01:55:58 GMT

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.

Re: Field not found > error in where condition

archire2102 — Wed, 28 Mar 2018 03:55:01 GMT

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.

Re: Field not found > error in where condition

vishsaggi — Wed, 28 Mar 2018 13:58:06 GMT

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)' ;

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

)) ;

Re: Field not found > error in where condition

olivierrobin — Wed, 28 Mar 2018 14:16:23 GMT

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

Re: Field not found > error in where condition

archire2102 — Wed, 28 Mar 2018 23:49:19 GMT

Hi Vishwa,

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

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

Thanks a lot.

Re: Field not found > error in where condition

vishsaggi — Thu, 29 Mar 2018 02:34:29 GMT

‌glad it worked