cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Learn how to build custom Python data connectors and further customize JMP’s Data Connector Framework with the Python Data Connector Demo, available now in the JMP Marketplace!
  • See how to create experiments to support product design and ID useful product features. Register for June 12 webinar, 2pm US Eastern Time.

JMP Wish List

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

automatic tables/update

☑ cool new feature
☑ could help many users!

☑ removes something that feels like a „bug“

☐ nice to have

☐ nobody needs it

 

 

What inspired this wish list request? 

As of v19, Tables/Update needs a lot of fine tuning:

Option 1: 

hogi_0-1758745544383.png

duplicate columns will be added in addition to existing columns. Such columns have to be identified manually and removed afterwards.
If not, after a few updates a huge number of columns will accumulate.

 

Option2: 

hogi_1-1758745578893.png

the user has to specify exactly which columns have to be added.

Maybe hundreds of columns ...

 

What is the improvement you would like to see? 

A fancy new automatic mode: "add non-existing columns" *)
JMP will compare the columns in the source table with the existing columns
- if a column exists, it is not added.

- if a column doesn't exist, it gets added.

 

*) 

  1. "add non-existing columnsin addition to none/all/selected:
  2. for "all", one could add a a checkbox:
    don't add duplicates of existing columns.

 

 

Why is this idea important? 

Often a user wants to add information from another table via Tables/Update

- They don't want to add hundreds of duplicates of columns which are already there in the table.

- They don't want to invest a lot of time to decide column by column if the column is already available or if the column is new.

 

 

 

other wishes from hogi_2-1702196401638.png

2 Comments
hogi
Level XIII

This graph shows how data tables get polluted by the current mode of Tables/update:

hogi_0-1758745178285.png

from Tables/Update changed! 

Status changed to: Acknowledged