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.

[master_student]

I didn't create the qvw file but after reading this blogPreceding Load

I can confirm that the preceding load is used.

Thanks

[sasiparupudi1]

You are missing a group by clause .Please check your sql if it actually returning the max value or not

[mayankraoka]

Hi Wiem,

When you are Loading table without preceding load will not allow you to use QlikView functions.check “Preceding load” and see how the load script changes.This should solve your issue.

Regards,

Mayank

[svinnakota]

Hi,

Just call the column from the sql and apply max in Load Statement.

Ex:

Load max(reference_Date) asMax_date

SQL : Select reference_date from ....

          where .....

And while using Aggr function on a field the format changes but don't worry about that.  For comparison it works fine.

And if possible share the Script in text file with dummy data or at least the code which you tried. Let me know your comments.

[rwunderlich]

Your DB system is probably returning max_date as upper case MAX_DATE. Try to reference it as MAX_DATE in the LOAD statement.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[maxgro]

remove the load .....

and just try

Temp:

select max(reference_date) as max_date

from ...

where ....;

exit script;

open the table editor (ctrl-t); is there a Temp table with a max_date field (or maybe MAX_DATE) ?