Joining contents of two tables into one new table

[bhmiller89]

I have two tables that each have a Job Number and a Status. 

Table 1: "Active Projects" columns "Job Number" and "Status"

Table 2: "BW Projects" column "BW Job NUmber" and "BW Status"

I need to write a third column in each table telling true/false whether or not there exist Job Numbers in one table but not the other, and I need to do it both ways.

Example: BW Job Number 2017-DAT-J01 does not exist in "Active projects" but exists in "BW PRojects" 

Job Number 2017-DAT-J02 does not exist in "BW Projects" but exists in "Active Projects" 

[v-huizhn-msft]

Hi @bhmiller89,

Have you resolved your issue? If you have, welcome to share your solution or mark the right reply as answer. More people will benefit from here.

Thanks,
Angelia

[v-huizhn-msft]

Hi @bhmiller89,

If you can create a one-to-one relationship between your two tables as the @parry2k shown? If you could, you can create a calculated column using the similar formula below in Table1.

exist=IF(ISBLANK( RELATED(Table2[Job Number])),"False","True")

Best Regards,
Angelia

[parry2k]

check if this help.

https://drive.google.com/file/d/0B4dPgH9_BPBrUWdOSTFYaGw4STQ/view?usp=sharing