topic Re: Field cannot be found when trying to load the script in App Development

Field cannot be found when trying to load the script

KayPong — Sat, 16 Nov 2024 18:10:58 GMT

When I am trying to load Line Y in the following script in the Load Script Editor, I am returned with an error that [KPI.Target] cannot be found whereas Line X is perfectly ok without the presence of Line Y. May I have your advice on what I had done incorrectly?

[Overview]:

Load
[KPI Key]
, [KPI.Target] as [Target] //Line X
, [KPI.Threshold] as [Threshold]

Resident [KPI];
drop Tables [KPI];

Left Join ([Overview])

Load
[KPI Key]
,sum([A.Case - Dengue])/$(vPopYear)*100000 as [Measurement]
,if( sum([A.Case - Dengue])/$(vPopYear)*100000 < [KPI.Target] , 1, 0) as [Green] // Line Y

resident [A]
group by [KPI Key];

Re: Field cannot be found when trying to load the script

KayPong — Thu, 27 Aug 2020 07:29:10 GMT

Can someone provide me some light to the above? thank you!

Re: Field cannot be found when trying to load the script

brunobertels — Thu, 27 Aug 2020 11:14:34 GMT

you rename KPI.Target as Target , but call in your left join KPI.target

try to change your mesure :

,if( sum([A.Case - Dengue])/$(vPopYear)*100000 < [Target] , 1, 0) as [Green] // Line Y

[Overview]:

Load
[KPI Key]
, [KPI.Target] as [Target] //Line X
, [KPI.Threshold] as [Threshold]

Resident [KPI];
drop Tables [KPI];

Left Join ([Overview])

Load
[KPI Key]
,sum([A.Case - Dengue])/$(vPopYear)*100000 as [Measurement]
,if( sum([A.Case - Dengue])/$(vPopYear)*100000 < [KPI.Target] , 1, 0) as [Green] // Line Y

resident [A]
group by [KPI Key];

Re: Field cannot be found when trying to load the script

Kushal_Chawda — Thu, 27 Aug 2020 13:13:20 GMT

You have renamed the [KPI.Target] in line X so in Line Y you need to provide the renamed field name which is "Target"

Re: Field cannot be found when trying to load the script

KayPong — Fri, 28 Aug 2020 02:51:05 GMT

I still get returned with an error that Target is not found when I changed Line Y to the following

,if( sum([A.Case - Dengue])/$(vPopYear)*100000 < [Target] , 1, 0) as [Green]

Re: Field cannot be found when trying to load the script

Vegar — Fri, 28 Aug 2020 03:26:11 GMT

You are loading resident from table [A]. You give us no further info about this table. Have you checked that this table contains the KPI.Target field ?

Re: Field cannot be found when trying to load the script

KayPong — Mon, 31 Aug 2020 10:37:35 GMT

Thanks Vegar.

Yes the problem lies in table A must contain KPI.Target which previously it was not there. I have used a temporary table to join it and now it works.