topic Re: Field not found error in resident load in QlikView

Field not found error in resident load

ananyaghosh — Wed, 25 Nov 2020 16:16:04 GMT

hi,

For the following script I am getting field not found error:

[Max_Dim_time]:
load date(floor(max("UPD_TS")), 'DD/MM/YYYY') as "Max_Upd_Time" resident [Dim_Office_Updated_Date] order by "Max_Upd_Time" DESC;

I have traced that for this portion of code : order by "Max_Upd_Time" DESC i am getting error.

Please help me for this.

Thanks,

Sandip

Re: Field not found error in resident load

Anil_Babu_Samineni — Thu, 02 Mar 2017 12:38:52 GMT

Can you send full script. I mean before resident load file

Re: Field not found error in resident load

ananyaghosh — Thu, 02 Mar 2017 12:42:13 GMT

[Dim_Office_Updated_Date]:
load [UPD_TS] from $(vExtractPathName)\Dim_Office.qvd(qvd);

[Max_Dim_time]:
load date(floor(max("UPD_TS")), 'DD/MM/YYYY') as "Max_Upd_Time" resident [Dim_Office_Updated_Date] order by "Max_Upd_Time" DESC;

Re: Field not found error in resident load

tresB — Thu, 02 Mar 2017 12:42:47 GMT

You can't use a field in the Order By clause which is being created in the same load. Try creating your "Max_Upd_Time" field in the previous load and then try like:

[Dim_Office_Updated_Date]:
load [UPD_TS],

date(floor(max("UPD_TS")), 'DD/MM/YYYY') as "Max_Upd_Time"

from $(vExtractPathName)\Dim_Office.qvd(qvd);

[Max_Dim_time]:

Order

load "Max_Upd_Time"

resident [Dim_Office_Updated_Date] order by "Max_Upd_Time" DESC;