if Expression

[smilingjohn]

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

[Lakshminarayanan_J]

@smilingjohn 

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)

[BrunPierre · Accepted solution]

I believe that's the expected output

IF(WildMatch(LABEL,'*Mode0*'),NULL(),
IF(WildMatch(LABEL,'*NoModes*'),'No mode',LABEL)) AS LABEL

[BrunPierre]

@smilingjohn Is your question answered, please mark as such.