topic Re: get main data table() in Discussions

get main data table()

hogi — Sat, 20 Jul 2024 15:53:13 GMT

For linked data tables (either summary tables or linked subsets), CTRL + ALT + D or a click on

will take me to the "main" table

This is very convenient. Great that JMP is willing to share this knowledge.
To make the most of it:

Is there a JSL function to get the main table?

As of JMP18, there is a new function called is linked subset() that can be used to check if a data table is a linked subset.
https://community.jmp.com/t5/Discussions/How-to-know-if-a-table-is-a-linked-subset/m-p/619442/highlight/true#M81884

Due to the fact that this function is brand new, I am afraid that the answer to the posted question is:

No ...

Application Case:
Just imagine how often you generate a report from a summary table - and then face the difficulty how to save the script.
Actually, it's just a combination of

a) the source script for the summary table

b) the source script of the report
but it requires ~ 20 mouse clicks to save the combined script to the main table.

If there is a way to get the main table - all this could be triggered by a single click on a toolbar. cool!

Re: get main data table()

jthi — Sat, 20 Jul 2024 15:41:54 GMT

If you are scripting you should know the references, there is also << Get Data Table() for reports.

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");
gb = Graph Builder(
	Variables(X(:height), Y(:weight)),
	Elements(Points(X, Y), Smoother(X, Y))
);

dt_ref = gb << get data table();

If you wish to have the script in the original data table, you would use Save Script to Source Table

Re: get main data table()

hogi — Sat, 20 Jul 2024 15:49:44 GMT

Hm,
unfortunately, << get data table() just seem to work for reports (like you say) , but not for linked summary tables and subsets (what I need) :

same mouse click on the GUI , but JSL is not 1:1:

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );

dtsummary = dt << Summary(Group( :height ));
dtsub = dt<< Subset( All rows, Selected columns only( 0 ) );

maintable = dtsummary << get data table(); // doesn't work
maintable = dtsub << get data table(); // doesn't work

so: no?

Re: get main data table()

jthi — Sun, 21 Jul 2024 15:55:37 GMT

For interactive usage you would use Workflow builder (or enhanced log) to make it fairly simple. For scripting, currently, you would have to parse Source Script or Linked Subset table variable (doesn't exist for Summary) if you don't want to utilize references. There should be << Get Original Data Table (should have been added when << Is Linked Subset was added) but currently we don't have one.

Re: get main data table()

hogi — Sun, 21 Jul 2024 17:29:51 GMT

Agree, here is the wish:

yes, maybe: "get original data table". Let's see which name developers will pick ...

Re: get main data table()

jthi — Sun, 21 Jul 2024 17:39:45 GMT

Original Data Table is the name which is used in both Summary and Subset platforms as the named parameter is "Link to original data table", so I think it would be nice to have some consistency (main data table could be other option but then all the original data tables should be updated), but we will see.

https://www.jmp.com/support/help/en/18.0/#page/jmp/create-a-subset-data-table.shtml

Re: get main data table()

hogi — Mon, 22 Jul 2024 10:44:55 GMT

Ah, one can and ask there ...
Thanks, @jthi : )

Anyway, a JSL function would be nice ...