BookmarkSubscribe
Choose Language Hide Translation Bar
joickle
Community Trekker

Update existing table with new data without creating output table

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

0 Kudos
2 REPLIES 2
rossjason
Community Trekker

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

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

0 Kudos
DVLuna
Community Trekker

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

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

0 Kudos