Field not found

[master_student]

Hi,

I have one qlikview loader file. when I am trying to reload it is showing Field Not Found but I can able to see that field present in source table. Could anyone help me why it is like that.

Part of the log file :

29/08/2016 09:32:30: 0017    Temp:

29/08/2016 09:32:30: 0018    LOAD Date(Date#(max_date,'YYYYMMDD'),'DD/MM/YYYY') as DWDate

29/08/2016 09:32:30: 0019    select max(reference_date) as max_date

29/08/2016 09:32:30: 0020    From ...."

29/08/2016 09:32:30: 0021    WHERE chain_id in('L_Aggregate_KPI') and chain_status in('Completed Successfully')

29/08/2016 09:32:30:         Error: Field not found - <max_date>

29/08/2016 09:32:30:         General Script Error

29/08/2016 09:32:30:         Execution Failed

29/08/2016 09:32:30:      Execution finished.

sql query :

Thanks.

[MindaugasBacius]

Are those fields some how related?

I guess you do not have max_date in your Database but you're using it in Date#(max_date). That could be a reason.

You may see max_date field after executing the sentence because you have written:

select max(reference_date) as max_date.

[mayankraoka]

Hi Wiem,

Check using max_date column as max(reference_date)

If the loading statement is same you have to use original name rather then alialsing

Regards,

Mayank

[master_student]

I don't have max_date in my data base, I have reference_date but I am renaming it into max_date.

select max(reference_date) as max_date

[Anil_Babu_Samineni]

Are you using preceding load?

[mayankraoka]

Hi,

Can you please share your app or script image here?

Regards,

mayank

[MindaugasBacius]

Then instead of:

Date(Date#(max_date,'YYYYMMDD'),'DD/MM/YYYY') as DWDate

Try this:

Date(Date#(max(reference_date),'YYYYMMDD'),'DD/MM/YYYY') as DWDate

[master_student]

what do you mean by preceding load please?

Thanks

[master_student]

yes but it used to work correctly why this error appears?

[mayankraoka]

Hi Wiem,

Please refer below blog for Preceding load.This will help you.

https://community.qlik.com/blogs/qlikviewdesignblog/2013/03/04/preceding-load

Regards,

Mayank