Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
Below is my requirement :
I would like to implement the following logic (I want to use Category 2 for the split and leave Category 3 reporting the existing data)
Where category 3 is like BEL% then set category 2 = Incident
Where category 3 is null then set category 2 = Unclassified
Else set category 2 = Change
I'm trying something like this :
=if(match(Category3,'_BEL%'),'Incident',
if(match(Category3,'-'),'Unclassified','Change'))
But it's not working. Kindly help!
Thanks,
AS
I assume you need a wildmatch...
=if(wildmatch(Category3, '*_BEL*'), 'Incident',
if(IsNull(Category3) or Category3 = '-', 'Unclassified', 'Change'))
=if(match(Category3,'_BEL%'),'Incident',if(IsNull(Category3) or Category3 = '-','Unclassified','Change'))
K N,
In my case and in ur suggestion still I'm having issue:
Thanks,
AS
Amit
try this
=if(match(Category3,'%_BEL'),'Incident',if(IsNull(Category3) or Category3 = '-','Unclassified','Change'))
or
=if(match(Category3,'*_BEL'),'Incident',if(IsNull(Category3) or Category3 = '-','Unclassified','Change'))
Sorry same result!
Can you share the sample app?
Hi,
You have to use * as wildcard search not % try with *
Regards
Sorry not possible , but i can share this:
Thanks,
AS
Replace % with *