cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
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