cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar

Tables join: option to update main table

☑ cool new feature
☑ could help many users!

☐ removes a „bug“

☐ nice to have

☐ nobody needs it

 

#myTop10_2023
(either this one or Speed up Tables/Update )

as we have a workaround for Tables/Update, also this one is no longer needed

 

What inspired this wish list request? 

Tables/Join is a powerful tool to merge different data tables.

The only disadvantage: it generates a new data table instead of updating the main table.

 

I often have a table, with table dozens of table scripts which evolved over time - and Dashboards which refer to this table.

To widen the analysis, I want to add a column to the table - but Tables/Join generates a new table.

 

What is the improvement you would like to see? 

Please add an option in Tables/Join: Update main table.

If the option is enabled, the platform should update the main table instead of generating a new one.

 

If Jmp developers fear that Tables:Join gets too crowded by this option, they could hide the option behind a shift-click or invisible to other users.

 

Why is this idea important? 

There is no fast way to merge new columns to a data table. 

Table/Join is almost the perfect tool - but it generates a new table.

The additional setting will solve the issue.

 

 

 

 

more wishes submitted by  hogi_2-1702196401638.png

14 Comments
hogi
Level XII

cool!

Fuzzymerge for time + "Match columns" for some additional columns

hogi
Level XII

@FN There is already a separate Wish for FuzzyMerge:

Add fuzzy join / asof merge / join by columns which do not have exact matches 

... from 2022.

Unfortunately, the status was still "New" (Juliy 2023) - perhaps due to 0 Kudos up to now?

Status changed to: Acknowledged
 
SamGardner
Level VII
Status changed to: Investigating