Wildcard in apply map in qliksense!

[srini]

Hi Friends,

Very good Day!

I am looking for some help in using wildcard in apply map during load. 

I have used the below code to get this done but it is not working fine for me.

My code:

Maptable:
Mapping Load * Inline
[
OBS Unit PathMapping-FROM,OBS Unit PathMapping-TO
ALL/HOST/IT/RBWM Technology/RBWM Sales & Distrib*,Sales & Distribution
ALL/HOST/IT/RBWM Technology/RBWM SSP (RTN09803)/*,SSP
ALL/HOST/IT/RBWM Technology/RBWM Retail Business*,RBB
ALL/HOST/IT/RBWM Technology/RBWM Global Standard*,Global Standards
];

RawData:
LOAD
"Resource Code",
Resource,
"Resource Manager",
Status,
"Hours",
// Mid([OBS Unit Path], 33, 24)as [OBS Unit Path],
// applymap('Maptable', Mid([OBS Unit Path],33) ),
// APPLYMAP( 'Maptable', [OBS Unit Path]) AS [OBS Unit Path],
APPLYMAP( 'Maptable', left([OBS Unit Path],48)) AS [OBS Unit Path],
"Billable Resource?",
"Week",
Email
FROM [lib://Clarity/RBWM Exceptions Report *.xlsx]
(ooxml, embedded labels, table is [Raw Data])
WHERE WildMatch ("OBS Unit Path",'*Sales & Distribution*','*Global Standards*','*SSP*','*Retail Business*');

this doesn't give me the mapped name it is directly getting the names not the mapped one.

output:

ALL/HOST/IT/RBWM Technology/RBWM Sales & Distrib
ALL/HOST/IT/RBWM Technology/RBWM SSP (RTN09803)/
ALL/HOST/IT/RBWM Technology/RBWM Retail Business
ALL/HOST/IT/RBWM Technology/RBWM Global Standard

Expected result:

Sales & Distribution

SSP

RBB

Global Standard

your help is much appreciated!

Thanks!

[PrashantSangle]

You can not use newly created field in same load. Either use preceiding load or resident load to apply wildmatch in where clause.

[srini]

Hi Prashant, wildmatch is where clause is working fine in my code. My issue is applymap is not working it is not giving me the new name. Thanks!

[srini]

any help on this?