Subscribe Bookmark RSS Feed

Joining to master table

Hegedus

Community Trekker

Joined:

Jun 23, 2011

I have 2 data tables that I want to join by row numbers.  They both have the same number of rows.  I want to add the columns of the second table to the first (Master).  Here are the settings for the join.

8382_join.png

Needless to say this does not work.  Instead of updating the Master table it creates a new data table, but with only the columns from the master table.  None of the columns from the second table are included.

If I deselect "Update main table with data from second table", I get an output table with columns as expected, i.e. all the columns from master and all the columns from second table.  But the master table is not updated and I have yet another data table.

Is Join with Update broken?

1 REPLY
pmroz

Super User

Joined:

Jun 23, 2011

You might be able to use Tables > Update instead.  However this option doesn't include matching by row number.  You could add a row number column to each table and then use update with those columns.  Adding a row number column to a table was recently mentioned in this thread.