Loading Nested IF( MATCH( ..WILDMATCH() Statements BUT the Else (or "otherwise") element is not being applied

[Zee]

Loading an IF( MATCH( ..WILDMATCH() statement BUT the Else (or "otherwise") element is not being applied.      

i.e. I am having trouble MATCHing Team_D. 

• IF Busines_Unit is 'Unit_1' = Team_A
• IF Busines_Unit is 'Unit_2' or 'Unit_3' AND industry is 'Motor' = Team_B, 
• IF Busines_Unit is 'Unit_2' or 'Unit_3' AND industry is 'Real Estate' = Team_C
• IF Busines_Unit is 'Unit_2' or 'Unit_3' AND any other value for industry = Team_D

When I run the below code, no results are being applied to Team_D **But it works for all other teams***

LOAD *,

IF(MATCH(Business_Unit, 'Unit_1'), 'Team_A',

IF(MATCH(Business_Unit, 'Unit_2', 'Unit_3'),

PICK(WILDMATCH(Industry, 'Motor',  'Real Estate'),  'Team_B', 'Team_C')), 'Team_D'))                 

AS Team;

Thanks in advance 🙂

[rwunderlich · Accepted solution]

I think your Pick() should look like:

PICK(WILDMATCH(Industry, 'Motor',  'Real Estate', '*'),  'Team_B', 'Team_C','Team_D')      

-Rob