cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bhmiller89 Member
Member

Joining contents of two tables into one new table

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" 

3 REPLIES 3
Super User
Super User

Re: Joining contents of two tables into one new table

check if this help.

 

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




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut! Connect with me on Linkedin






v-huizhn-msft Super Contributor
Super Contributor

Re: Joining contents of two tables into one new table

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

v-huizhn-msft Super Contributor
Super Contributor

Re: Joining contents of two tables into one new table

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