JSL script - After update table, run the embedded formula
Oct 22, 2018 1:52 AM(3882 views)
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" ) );
@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.