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(
with(dt2),
match(:name=:name),
ignore missing,
add columns from update(none)
);
but that doesn't seem to work. Does anyone know what the correct option is for this?
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
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
Thanks Jeff!
realized my update table had multiple entries for the same match col.