cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
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

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

- He doesn'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

1 Comment
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!