Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a below column in my DB which looks like the below screenshot. I want to remove 'Mode0' and also want to rename
'NoMode's as 'No Mod' to achive this i am trying to use this expression
=if(not Match(LABEL,'Mode0'),LABEL) and if(LABEL='NoModes','No mode',LABEL) but this is not working can anyone please help me on this
Thanks in Advance
I believe that's the expected output
IF(WildMatch(LABEL,'*Mode0*'),NULL(),
IF(WildMatch(LABEL,'*NoModes*'),'No mode',LABEL)) AS LABEL
Please fine the below script and screenshot for your reference.
Script:
Test:
Load * Inline
[
ID,Sales
1,Mode0
2,Mode1
3,Mode2
5,NoMode
];
Test1:
NoConcatenate
Load
ID,
Sales,
IF(Sales<>'Mode0',Sales)as sales1
Resident Test;
drop Table Test;
Expression:
=if(sales1='NoMode','No Mode',sales1)
I believe that's the expected output
IF(WildMatch(LABEL,'*Mode0*'),NULL(),
IF(WildMatch(LABEL,'*NoModes*'),'No mode',LABEL)) AS LABEL
@smilingjohn Is your question answered, please mark as such.