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?
An addition function:
dt << get list of linked subsets()
will help. Then I can close the subsets via JSL.
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)