cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Discussions

Solve problems, and share tips and tricks with other JMP users.
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