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

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

david707 — Wed, 31 Jul 2024 09:34:16 GMT

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?

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

jthi — Wed, 31 Jul 2024 09:39:30 GMT

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

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());