I'd like to join two data tables by a matching column. However, I do not want JMP to create a new table with the result. The joined columns from the second table should be appended at the first table. I thought the "Update main table ..." option would do this, however it does not work for me (tested JMP 14 and 15). How can I make this work? Here's a minimal example demonstrating the issue:
I have to table "Untitled 3" and "Untitled 4", which I want to join by matching values in "Column 1". The join works perfectly if it creates a new table (option "Update main table ..." disabled), the correct result is contained in table "Untitled 17":
However, if I activate the option "Update main table ...", after clicking "Create" still a new table is created, but it is only a copy of table "Untitled 3" and also in table "Untitled 3", the data is unchanged and the data from table "Untitled 4" is not contained:
Here, the join has actually not been performed. I would rather expect that after performing the join in the second screenshot, table "Untitled 3" would contain the additional column "Column 3" with the data as in table "Untitled 17" in the first screenshot.
Thanks for any hint.