BookmarkSubscribeRSS Feed
Choose Language Hide Translation Bar
Highlighted
JesperJohansen

Community Trekker

Joined:

Apr 15, 2013

Cannot permanently unhide columns from virtual join

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

  1. 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?
  2. 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

BR
Jesper
2 ACCEPTED SOLUTIONS

Accepted Solutions
chungwei

Staff

Joined:

Jun 23, 2011

Solution

Re: Cannot permanently unhide columns from virtual join

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

Staff

Joined:

Jun 23, 2011

Solution

Re: Cannot permanently unhide columns from virtual join

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.

6 REPLIES 6
ih

Community Trekker

Joined:

Sep 30, 2016

Re: Cannot permanently unhide columns from virtual join

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

Staff

Joined:

Jun 23, 2011

Solution

Re: Cannot permanently unhide columns from virtual join

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. 

ih

Community Trekker

Joined:

Sep 30, 2016

Re: Cannot permanently unhide columns from virtual join

Yes please!

 

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

chungwei

Staff

Joined:

Jun 23, 2011

Solution

Re: Cannot permanently unhide columns from virtual join

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.

JesperJohansen

Community Trekker

Joined:

Apr 15, 2013

Re: Cannot permanently unhide columns from virtual join

@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?

BR
Jesper
ih

Community Trekker

Joined:

Sep 30, 2016

Re: Cannot permanently unhide columns from virtual join

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