I have virtually joined two tables (Link Ref and Link ID). I have two problems: * When I open the only referencing (master) table the joined columns are not shown. Can I not force the master table to open the linked table upon open? * When I both tables I do see the joined columns, but they are hidden by default. If I unhide some, this is apparently not saved anywhere, since they are again hidden after: Close -> Open of both tables. How can I avoid having to unhide these columns every time I open my tables I hope someone can help. Jesper

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Cannot permanently unhide columns from virtual join

JesperJohansen

I have virtually joined two tables (Link Ref and Link ID). I have two problems:

When I open the only referencing (master) table the joined columns are not shown. Can I not force the master table to open the linked table upon open?
When I both tables I do see the joined columns, but they are hidden by default. If I unhide some, this is apparently not saved anywhere, since they are again hidden after: Close -> Open of both tables. How can I avoid having to unhide these columns every time I open my tables

I hope someone can help.

Jesper

Accepted answers

chungwei

The current version does not have any options.

In the next version, maybe we can add some preference to be saved with the Link Reference property, like always save the state of the virtual linked columns.

chungwei

As to your first question, the linked table is automatically opened by any process that requires the data from the table, eg, if you run some platform that has a reference to a column from the linked table.

Again, we can add a option in the Link Reference property to ask the referencing column to trigger the linked table to be automatically opened.

Audrey_Shull

Following up on this post from a few years ago. The auto-open feature was added in JMP 15, and the ability to permanently unhide columns was made possible in JMP 16.

All comments

I usually open linked tables with a script, so instead of directing users to a .jmp file, direct them to a .jsl file. I also tried saving a script to the data table to open the other table and unhide columns but if a user skipped that they could unexpected results.

Names default to here( 1 );

//Open the tables
dt1 = Open( "$Sample_data/big class.jmp" );
dt2 = Open( "$Sample_data/big class families.jmp" );

//Set up the link, normally do not need these lines
dt2 << New Column(
	"nameagesex", Character, "Norminal",
	Formula( :name || Char( :age ) || :sex ),
	Set Property( "Link ID", 1 )
);
dt1 << New Column(
	"nameagesex", Character, "Norminal",
	Formula( :name || Char( :age ) || :sex ),
	Set Property( "Link Reference", Reference Table( "big class families.jmp" ) )
);

//Unhide Columns
Column( dt1, "picture[nameagesex]" ) << Hide( 0 );

chungwei

The current version does not have any options.

In the next version, maybe we can add some preference to be saved with the Link Reference property, like always save the state of the virtual linked columns.

chungwei

Again, we can add a option in the Link Reference property to ask the referencing column to trigger the linked table to be automatically opened.

Yes please!

I submitted this to the 'JMP Wish List', vote for the idea here.

JesperJohansen

@chungwei

It seems like the functionality I am looking for is not there. Consider this a feature request then

@ih

Thank you. By voting you med to give kudo, right?

Yes, a kudo seems to signify a vote over there.

Audrey_Shull

Following up on this post from a few years ago. The auto-open feature was added in JMP 15, and the ability to permanently unhide columns was made possible in JMP 16.