join based on conditions

[ValeriaBreve]

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 empty

Col1 and Col2/Col4 and Col5 if Col6 is empty

all Col1, 2 and 3 /Col 4,5 and 6 if  the latter are populated.

How would you do it? I have not found a good way to do such a "conditional" join....

Thanks!

Kind regards

Valeria

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

[RocketRod · Accepted solution]

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

[ValeriaBreve]

thanks!