topic Re: JSL script - After update table, run the embedded formula in Discussions

JSL script - After update table, run the embedded formula

ReginaHong — Mon, 22 Oct 2018 08:52:53 GMT

Hi,

I am trying to update my existing table on column name "Capacity". As you can see in the picture below, once the Capacity column is updated, "Predicted_Shipment_1" column need to change the value according to the fomula embedded inside. However, once I run the script below, the value in "Predicted_Shipment_1" column does not change according to the updated Capacity column. Is there anything wrong with my script below?

dt2 << Update(
With( dt3 ),
Match Columns( :Time = :Time ),
Add Columns from Update table( "Capacity" )
);

column(dt2,"Predicted_Shipment_1") << delete formula;

dt3 << Update(
With( dt2 ),
Match Columns( :Time = :Time ),
Add Columns from Update table( "Predicted_Shipment_1" )
);

At the end the value in column "Predicted_Shipment_1" updated in dt3 is the old value which is not according to the formula embedded inside. Anything wrong with the formula above?

Re: JSL script - After update table, run the embedded formula

uday_guntupalli — Mon, 22 Oct 2018 14:11:29 GMT

@ReginaHong,
When you delete the formula and re-create the column, there is no formula in the column to run that will update the values of the Predicted column. The values that are generated due to your update/join operation will be held in the column.

Re: JSL script - After update table, run the embedded formula

ReginaHong — Tue, 30 Oct 2018 07:14:25 GMT

Thank you for your replied. I have found solution for this. Just add in the syntax below and it will help to run the formula.

column(dt4,4) << Eval Formula(1);