Field not found error

[Foodie123]

Hello experts,

I am trying to reload my script but I am getting an error saying the Total_Loss_Cost field is not found and I'm not sure why.

I have attached the script below

Any help is appreciated.

Thank you.

[Foodie123]

Thank you. The exit script worked and no longer getting the error.

However, the export portion of the script is not running correctly. It is not exporting any data anymore. 

I do have this script before the export script portion.

I know you had mentioned to look at the data model- I did see that the Total_Loss_Cost field is under the Earnix Modeled LC by BrokerID_GW table.

[RafaelBarrios · Accepted solution]

Hi @Foodie123 

that means that your error is happening after the exit script.

you were probably doing something like 

load
...
Total_Lost_Cost 
...
...
RESIDENT Autobook;

and that field didnt exists on Autobook table.

and should be:

load
...
Total_Lost_Cost 
...
...
RESIDENT [Earnix Modeled LC by BrokerID_GW];

store [Earnix Modeled LC by BrokerID_GW] into ........;

hope this helps,

help users find answers! Don't forget to mark a solution that worked for you & to smash the like button! 

[Foodie123]

Thank you for all your help Rafael.