cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Register to attend Discovery Summit 2025 Online: Early Users Edition, Sept. 24-25.
  • New JMP features coming to desktops everywhere this September. Sign up to learn more at jmp.com/launch.
Choose Language Hide Translation Bar
vcoppens
Level II

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

Recommended Articles