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

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

as we have a workaround for Tables/Update, 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

15 Comments
hogi
Level XIII

cool!

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

hogi
Level XIII

@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
 
Status changed to: Acknowledged