Update Table script leaves empty column

vcoppens — Fri, 22 Dec 2023 12:10:56 GMT

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 )
);

Re: Update Table script leaves empty column

jthi — Fri, 22 Dec 2023 12:14:55 GMT

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).

topic Update Table script leaves empty column in Discussions

Update Table script leaves empty column

Re: Update Table script leaves empty column