463666_en-US

liliconcom

Update column with formula

Hi all,

I have two data table (dt1 & dt2). I need to add dt2's column (Col1) to dt1 with a formula in it. But when I update the table, the values from Col1 are empty. Seems to be a problem in the formula. Please help

 

current data table (dt1);     
dt1 << Update( With( dt2), Match Columns( :KeySample= :KeySample), Add Columns from Update table ( :Col1) );
dt1:Remarks << Formula ( If( :Col1== "Out of Range", "Out of Range", "" ));
 

  

Data TableOtherScriptingRe: Update column with formula

I am not finding an error with your code.  I adopted it to a couple of sample data tables that I have attached, and it works without error.

names default to here(1);
dt1=data table ("bc1");
dt2=data table("bc2");     
dt1 << Update( With( dt2), Match Columns( :name= :name, :sex==:sex),
 Add Columns from Update table ( :Age) );
dt1:Remarks << Formula ( If( :age== "12", "Out of Range", "" ));

Check to make sure that my code works on your copy of JMP.  If it does(which it should) then look to see how my sample data table's columns are different from your tables.

Re: Update column with formula

 Hi txnelson, from my example, the added column also has a formula which will become blank after update. I also tried delete formula before updating the table, but still, the column is blank