Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
Our World Statistics Day conversations have been a great reminder of how much statistics can inform our lives. Do you have an example of how statistics has made a difference in your life? Share your story with the Community!
Mar 17, 2015 9:36 AM
| Last Modified: Oct 18, 2016 3:51 PM(1916 views)
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.
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.
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.