Hello,
I am trying to add 2 columns in table (dt_delta) to table (dt) using update command by comparing 2 columns. dt has 40 rows with unique rows identified by "Age" column and dt_delta has 50 unique rows identified by Age.
Hence i am trying to add data from two columns, Var1 and Var2 in dt_delta to dt table by matching Age columns.
Var1 and Var2 columns have formula in them.
I copied the executed script and pasted in my JSL script but issue is when i run entire script, update doesn't happen everytime and when i select portion of script and try to execute it, it does update correctly.
Can you please advise.
dt << Update(
With( dt_delta ),
Match Columns ( :Age = Age ),
Add Columns from Update table( :Var1, :Var2 )
);