cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Sign-in to the JMP Community will be unavailable intermittently Dec. 6-7 due to a system update. Thank you for your understanding!
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.
  • JMP 19 is here! Learn more about the new features.

JMP Wish List

We want to hear your ideas for improving JMP. Share them here.
Choose Language Hide Translation Bar

Name Selection in Column: could be my favorite tool :) if ...

☐ cool new feature
☑ could help many users!

☐ removes a „bug“

☐ nice to have

☐ nobody needs it

 

 

Name Selection in Columns from the Rows/Row Selection  menu is great to define labels by selecting different subsets and writing the corresponding labels step by step into the same "label" column:

https://community.jmp.com/t5/Discussions/manual-grouping-extended-version/td-p/540203

 

The current behaviour of the function is:

a)  just do something if the user entered a value [This feature enables the user to "collect" information by writing values again and again to the same column - without over-writing existing labels in other rows]

b) If there is already a label in a selected row, it is replaced by the new label.

This is the reason why the function can not be used for "multiple response" entries:

A second response just replaces a first one.

 

My wish: an option to append the entered string, if a selected row already contains a value:

HolgerSp_1-1662204073023.png

 

This will allow to collect "multiple response" entries like in the example below.

best: a function that automatically handles the commas right (i.e. no comma for the first label).

 

Additional useful options:

- prepend text

- search and delete text

- search and replace text with another text

...

 

 

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt << New Column("activity", Character, "Multiple Response");

dt << Clear Select << Select Rows( [2, 4, 8, 9, 20, 25, 26, 35, 36] );
wait(2);
dt << Name Selection in Column( Column Name( "activity" ), Selected( " ,football" ) );
wait(2);
dt << Clear Select << Select Rows( [2, 4, 8, 12, 22, 27, 28, 29, 30] );
wait(1);
dt <<Name Selection in Column( Column Name( "activity" ), Selected( ", Tennis" ), Append=1 );

 

 

more wishes submitted by  hogi_2-1702196401638.png

5 Comments
Status changed to: Acknowledged

@hogi - Thank you for your suggestion! We have captured your request and will take it under consideration.

Status changed to: Investigating

@hogi Thank you for this suggestion, it has been submitted and is being evaluated for possible inclusion in a future release.

SamGardner
Level VII
Status changed to: Not Planned For Now

We appreciate the suggestion.  We do not plan to offer this in a near term future version of JMP.  Several options exists to do this, including:

 

  • Create separate columns for each name selection step, and then concatenate them
  • Use JMP Script (or, coming in JMP 17, a JMP Workflow) to do this

Writing an addin to do this, with a dialog as you suggested, could also achieve the final result.

hogi
Level XIII

OK, I am curious to see the new "JMP 17 workflow" :)

For those who want a JMP script I will add it to manual grouping - extended version? 

hogi
Level XIII

AddIn with many functions to TAG rows: QuickSelect Toolbar 

 

hogi_0-1702197320532.png