I am trying to write a script that will update my existing table without producing an output table. I have the following code which doesn't seem to work:
Data Table("Crea Table") << Update from Database(
"DRIVER=SQL Server Native Client 11.0;SERVER=REMOVED FOR SECURITY;",
,Merge Same Name Columns,
By matching Columns(:Lot_Day=:Lot_Day,:Lot ID=:Lot ID),
Drop Multiples(1,0),Name("Include non-matches")(1,0),
Preserve Main Table Order(1),
Can someone help me out?
Did you ever figure this out? Excel can do it...
I am a new JMP user, but I think I was dealing with the same issue a few weeks ago.
Please review the discussion: Updating JMP Data Tables
This discussion was an old discussion related to the issue, so I attached my questions and my final resolution to that discussion.
If it is the same issue I think I posted a resolution you can use.