topic Re: Update existing table with new data without creating output table in Discussions

Update existing table with new data without creating output table

joickle — Mon, 06 Jul 2015 14:24:58 GMT

Hi,

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;",

"EXECUTE Crea_Table"

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

//No Output

)

Can someone help me out?

Thanks

Re: Update existing table with new data without creating output table

rossjason — Thu, 29 Jun 2017 16:11:24 GMT

Did you ever figure this out? Excel can do it...

Re: Update existing table with new data without creating output table

DVLuna — Fri, 30 Jun 2017 23:54:23 GMT

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.

Dave