Update existing table with new data without creating output table

[#1]

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]

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

[#3]

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