Page 1 of 1

Getting the Distinct Values of A Shared Field from Two Different Tables

Posted: Thu May 21, 2020 4:54 pm
by Harry
Hi everyone,

I have two tables; Table A and Table B, which share a common field – Business Unit.
I want to create a new table that contains all of the distinct business units that exist in either Table A or Table B.

To date, I have used the Values() function but this has only given me the distinct values in ONE table. There may be scenarios where a particular business unit occurs in table A and not table B or vice versa so I need a solution that will be robust enough to handle this.

Any ideas?