cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
vcoppens
Level I

Update Table script leaves empty column

Hi,

I copied the following script from the Log window after updating the main table "...kopie" with the MacroREM column from update table "rem". The update works perfectly when executing manually, so I copied the script; however, when running the script, the MacroREM column is indeed created in the "kopie" main table, but left empty. 

 

See image: after running this code in script, the main table created the MacroREM column, but has no values.

Is this a bug, or any other advice?

 

 

// Update data tables
Data Table( "Master REMotion JMP kopie.jmp" ) <<
Update(
	With( Data Table( "rem" ) ),
	Match Columns(
		:Validated = :Validated, :Type = :Type, :Start = :Start, :End = :End,
		:ID = :ID, :SubType = :SubType
	),
	Add Columns from Update Table( :MacroREM ),
	Replace Columns in Main Table( None )
);

 

1 REPLY 1
jthi
Super User

Re: Update Table script leaves empty column

Without having access to your data my only guess would be that the data used for matching doesn't exactly match. One of the possible reasons could be for example that your timestamps aren't exactly the same (if Start and End are times).

-Jarmo