Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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);
can you explain with more detail information?
what is the replace value ? and what is expected output?
dear:
The attached data is replaced with the values on the picture
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);
Thank you perfect