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

[#1]

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? 

[#2]

Do the columns in both tables have the same Data Type and Modeling Type? If not, this might be the issue.

[#3]

Yup, I am actually changing them specifically to match before I run this update and they do match when I check them with the columns manager.

[#4 · Accepted solution]

Hi,

It looks like you are missing the curly brackets ({}) in the Replace Columns in the Main Table statement:

Replace Columns in Main Table({ :ExperimentID })

Also, you may need to list all the columns you want to update in that Replace Statement:

Replace Columns in Main Table( {:ExperimentID, Read Date, Exeperiment Type} )

Just a thought.

Best

TS

[#5 · Accepted solution]

I added the {} to the replace columns, but that didn't solve my problem. I am looking to only update the experiment ID, I want to match the others so it updates to the correct row. 

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

[#6]

I'm sorry to hear that it did not solve the issue.

Would you be able to share the SQL output and the table to be updated?

If not, have you tried updating the table "manually"? If it works, then the issue might be with the script (nothing obvious from my point of view).  There might be subtle differences in the data format between the SQL and destination tables (hidden characters?).

Best,

TS

[#7 · Accepted solution]

Solution found. It was unable to update Experiment ID as my sql return column was "ExperimentID" where the original data was "Experiment ID" (added space) so I'll add code into match those first and then I should be good