join based on conditions

Question

Hello,I would like to join 2 tables based on certain conditions.Ex. is below - I would like to jojn the first to second table based on:Col1/Col4 ONLY if Col5 is emptyCol1 and Col2/Col4 and Col5 if Col6 is emptyall Col1, 2 and 3 /Col 4,5 and 6 if&nbsp; the latter are populated.&nbsp;How would you do it? I have not found a good way to do such a "conditional" join....Thanks!Kind regardsValeria&nbsp;&nbsp;Col1Col2Col3&nbsp;&nbsp;Col4Col5Col6ResultAFG&nbsp;&nbsp;A&nbsp;&nbsp;result1BTY&nbsp;&nbsp;B&nbsp;&nbsp;result2CGD&nbsp;&nbsp;CGDresult3DH&nbsp;&nbsp;&nbsp;DH&nbsp;result4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Final Table&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Col1Col2Col3Result&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;AFGresult1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;BTYresult2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CGDresult3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DH&nbsp;result4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

rocketrod · Accepted Answer

Refer to this article&nbsp;Merging with date range using Power Query - Exceed

Forum Discussion

join based on conditions

2 Replies

Related content

conditional join

conditional join

Join 2 tables based on multiple conditions

CONDITIONAL JOIN

Join the community

Col1	Col2	Col3		Col4	Col5	Col6	Result
A	F	G		A			result1
B	T	Y		B			result2
C	G	D		C	G	D	result3
D	H			D	H		result4



Final Table

Col1	Col2	Col3	Result
A	F	G	result1
B	T	Y	result2
C	G	D	result3
D	H		result4