cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
jmpandvba
Level II

Workaround to "update" function in script

Hello JMP community,

 

I have a data table that is dependent on another data table. I've tried updating it with the update function, but it seems to not do anything. Instead, what this script is doing is opening a new data table window with the selected subset instead of updating the current table. How can I get it to update the currently open datatable "dt" with the subset of "dtU"? Thanks!

 

// Open Sample Data 
dt = Open("KrF CDU Data table.jmp");
dtU = Open( "Exposure_Summary_Data.jmp" ); 

// Making subset of data
dtU << Clear Column Selection();
dtU << Select Where(contains("KrF", :Type));  
Column(dtU,"F23")<< Set Selected(1); 
dtU << Invert Column Selection; 
dt1 = dtU << Subset(Selected Rows(1),Selected Columns(1,:Wafer Code));

// Updating with subset
dt << Update(With(dt1),By Matching Columns(name==name),);
10 REPLIES 10
gzmorgan0
Super User (Alumni)

Re: Workaround to "update" function in script

Match needs to specify as many columns that make this unique. So you might need match by multiple columns, for example :Experiment name == :Experiment name, :Stack==:Stack, :Wafer Code==:Wafer Code, :Metrology Recipe==:Metrology.

These are just suggestions.

 

You need to choose which columns make each row unique, then match accordingly.