cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
0 Kudos

Table: list all linked subsets

☐ cool new feature
☐ could help many users!

☑ removes a „bug“

☐ nice to have

☐ nobody needs it


What inspired this wish list request? 

from @ https://community.jmp.com/t5/Discussions/How-to-know-if-a-table-is-a-linked-subset/m-p/655280/highli... 

If I try to concatenate tables with the option Append to first table,

the script stops with the message:

 

Cannot append to table: Big Class. Possible reasons for this include: the table is locked, the table is in a platform with a by group, or there is a linked subset of the table. in access or evaluation of 'Concatenate' , Concatenate(/*###*/Data Table( "Subset of Big Class" ),	Append to first table)

 

 

The error message was very helpful to identify the issue.
But how to make the script robust against linked subsets?

 

What is the improvement you would like to see? 

An addition function:

dt << get list of linked subsets()

will help. Then I can close the subsets via JSL.

 

 

Why is this idea important? 

code won't crash if there are linked subsets.

Alternatives:

  • Jmp updates the linked data tables
  • Jmp cuts the link automatically
  • concatenate get a new option: Jmp_is_allowed_to_close_linked_data_tables_if_this_is_needed_to_run_this_concatenate(1) 

 

 

 

more wishes submitted by  hogi_2-1702196401638.png