cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
david707
Level III

How to script "save difference summary" of "compare data tables"

Hi,

I have a script that calls the compare data tables platform using:

DTOriginal << Compare Data Tables(Compare with( DT2new ),Hide columns with no differences( 0 ),Hide rows with no differences( 0 ));

After I can manually use the top left red triangle to "save difference summary", however this isn't recorded in the log or workflow builder. Can it be scripted and if so, how?

1 REPLY 1
jthi
Super User

Re: How to script "save difference summary" of "compare data tables"

You can quite often find the messages with the exact name of the menu item from Script Index

jthi_0-1722418685470.png

In this case I think the example doesn't work due to incorrect syntax, so remove invisible from it

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Students1.jmp");
dt2 = Open("$SAMPLE_DATA/Students2.jmp");
obj = dt << Compare Data Tables(compare With(Data Table("Students2")));
summaryDT = (obj << save difference summary());
-Jarmo

Recommended Articles