cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
joickle
Level I

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

2 REPLIES 2
rossjason
Level II

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

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

DVLuna
Level III

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