11812_en-US

liliconcom

update table using JSL without adding missing columns

I'm trying to update the values of a specific column in a data table using values in another data table. The update function seems like the logical choice but it always seems to add extra unmatched columns to the updated table. From the update utility there is an option for this

However there isn't any mention of this in either the scripting index

or in the help search. I've tried

 

 

dt << update(
&nbsp;&nbsp;&nbsp;&nbsp; with(dt2),
&nbsp;&nbsp;&nbsp;&nbsp; match(:name=:name),
&nbsp;&nbsp;&nbsp;&nbsp; ignore missing,
&nbsp;&nbsp;&nbsp;&nbsp; add columns from update(none)
);

 

 

but that doesn't seem to work. Does anyone know what the correct option is for this?

Data TableScriptingRe: update table using JSL without adding missing columns

This isn't working for me. My main table is stubbornly refusing to update accurately.

The table updates but the matching columns aren't behaving as expected.

The matching columns are long strings with "/" they are file paths is this expected?

 

Is this because there is a graph built off of it? 

 

The examples seem to work but I'm actually reverting to

some kind of array iteration approach because I can't get this function to behave.

JMP16.1

Re: update table using JSL without adding missing columns<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

Thanks Jeff!

Re: update table using JSL without adding missing columns

You're almost there!

 

Looking at the Source script that's added to my table after I do an Update with that option I see that the script is:

Data Table( "Trial1.jmp" ) << Update(
  With( Data Table( "Little.jmp" ) ),
  Match Columns( :popcorn = :popcorn, :oil amt = :oil, :batch = :batch ),
  Add Columns from Update table( None )
);

 

-Jeff