Table Update: How to update only selected columns?

Monomorphist

This should be a quick one:

Table update: How to update only selected columns? 

 

Data Table( dt1 ) << Update(
	With( Data Table( dt10 ) ),
	Match Columns( :SAMPLE = :SamID ),
	Add Columns from Update Table( None ),<BR />    ### Update Selected Columns (:Type, :Method) ###<BR />)

It's simple when done manually, but in the script? There's nothing in the scripting guide (only how to avoid adding columns). My various guesses and trials (eg. see inside  ###  in above script) do not work.

jthi

If you have JMP16 you can perform the action once manually and then get the script from enhanced log, most likely what you are looking for is Replace Columns in Main Table()

Data Table("Big Class") << Update(
	With(Data Table("Subset of Big Class")),
	Match Columns(:name = :name),
	Replace Columns in Main Table(:age)
);