☑ cool new feature
☑ could help many users!
☐ removes a „bug“
☐ nice to have
☐ nobody needs it
An everyday problem in daily jmp data handling is how to get updated data sets efficiently into jmp:
You add some lines to an excel file - perhaps also some columns - and want to check the graphs that you just have generated in jmp.
When importing csv or excel files, a "source" script is added atomatically - and one could run it again to get an updated version of the data into jmp.
But the new data is imported as a second data set - independent of the first one. So, if there are already dozens of graphs, analysis windows and dashboards linked to the original table, it's quite some effort to update everything.
I'd love to have a universal "update" button that copies any update of the input (e.g. Excel) data to the jmp table:
- adds new rows
- deletes removed rows
- adds new columns
(keeps previous columns, even if they were deleted - just in case
like the "reread" button in Cornerstone.
A first step in this direction and very helpful is Martin's "update from Excel" script:
https://community.jmp.com/t5/Martin-Demel-s-Blog/Updating-a-JMP-data-table-from-a-spreadsheet-made-e...
... but some of the above functions are missing.
And:
The script should be added automatically - like the "source" script, right?