583933_en-US

liliconcom

JSL question: Update missing column entries from another column

Hi all,

 

I need to update missing column entries in a data table, with entries from another older column. Using JSL code, and on JMP 14.

Here is the code I am trying to work, but it keeps on throwing error "attempting to assign to an object... L-value access.."

Any help will be appreciated..

 

dt=current data table();
Newcols={ "anew", "bnew", "cnew"};
oldcols={ "a", "b", "c"};
  
  
//---Update entries from old cols if new column entry is missing
For( k = 1 , k <= Length( oldcols ), k++,
    
  
  For Each Row(
   temp = column(dt, Newcols[k]); 
   oldc = column(dt, oldcols[k]);
   column (dt,Newcols[k]) = If( Is Missing( as column(dt,Newcols[k]) ) , oldc , temp) ;
   );
 );

 

 

Data TableScriptingWindows