Conditional Join

[Anonymous]

Trying to Join same table twice but with two different conditions:

HeadCount:
Load
Region,
EmpID,
Unit
From HeadCount.qvd;

Left Join (HeadCount)
Load
Unit,
Region,
Final_Unit
From UnitInfo.xlsx
(ooxml, embedded labels, table is Sheet1)
Where Unit <> 'Commodities';

Left Join (HeadCount)
Load
Unit,
Region,
EmpID,
Final_Unit
From UnitInfo.xlsx
(ooxml, embedded labels, table is Sheet1)
Where Unit = 'Commodities'

First left join should join by Unit and Region and second should joing by Unit, Region and EmpID, but above approcah does not seem to work.

[swuehl]

Second Join will also join on Final_Unit, won't it?

[Anonymous]

Yeah, i guess. But do you understand what I'm trying to achieve ?  FinalUnit joined in but in two different ways.

I need FinalUnit joined in but in two different ways.

Thank you.

[jolivares · Accepted solution]

Try to change the name of field FinelUnit of the first table, before the join.

[Anonymous]

Thank you Jolivares. I had to introdue another field for second join and then on my chart used conditional dimension to pull the right one.