cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Browse apps to extend the software in the new JMP Marketplace
Choose Language Hide Translation Bar
chappe
chappe
Level I

Getting error "No column was added. No data was replaced. at row 1 in access or evaluation of 'Glue'" When trying to run Update

3 hours ago (31 views)

I'm at a complete loss, my code is querying a sql database and returning a one line result or a blank table, I am then trying to update the ID column of my jmp datatable with that information. It now won't match on any column between these tables, doesn't matter if I make one that's identical and try to run the update. I am on JMP18.

dt100 << Update(
			With( Data Table( dt200 ) ),
			Match Columns(
				:Read Date = :ReadDate, :Experiment Type = :ExperimentType,
				:Plate Size = :PlateSize, :Plate Type = :PlateType,
				:Dispense Mode = :DispenseMode, :Probook Number = :ProbookNumber,
				:Probook Page Number = :ProbookPageNumber
			),
			Add Columns from Update Table( None ),
			Replace Columns in Main Table( :ExperimentID )
		);

 

Any suggestions? 

0 Kudos
0 REPLIES 0