Replace Multiple conditions

[qingkong]

I want to replace these values, so the first column is ROH WH, and the second column is ROH MFG.

How do I write the replace function

[Chanty4u]

can you explain with more detail information?

what is the replace value ?   and what is expected output?

[qingkong]

dear：
            The attached data is replaced with the values on the picture

[GeorgePhilips23 · Accepted solution]

SLoc:
LOAD
SLoc,
If(WildMatch(SLoc,'P101','P102','P103','P104','P105'
,'P106','P107','P108','P109','P110','P111','P401','P402'),'ROH WH',
If(WildMatch(SLoc,'P301','P302','P303','P304','P305'
,'P306','P307','P308'),'ROH MFG')) as Modified_SLoc

FROM [lib://DataFiles/TEXT.xlsx]
(ooxml, embedded labels, table is Sheet1);

[qingkong]

Thank you perfect

[MarcoWedel]

https://help.qlik.com/en-US/sense/February2022/Subsystems/Hub/Content/Sense_Hub/Scripting/MappingFun...