Matching 2 tables using Table\Join and Table\Update without success
Attached are Tables A, B and C. Table A has 30 entries by Peter. Table B has 8,790 entries by Jane. Table C is the correct joined table done manually. I want to match the entries by Peter and Jane and create a subset only with "Locations" in Table A, thus Table C. I had used Table\Join and Table\Update but the results were not accurate. For example, if you use the Location=-216,161, below should b...