Subscribe Bookmark RSS Feed

Update existing table with new data without creating output table

joickle

Community Trekker

Joined:

Jun 30, 2015

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
rossjason

Occasional Contributor

Joined:

Feb 3, 2017

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

DVLuna

Occasional Contributor

Joined:

Jun 10, 2017

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