Field not found error in resident load

[ananyaghosh]

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

[Anil_Babu_Samineni]

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

[ananyaghosh]

[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;

[tresesco · Accepted solution]

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;