Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I wish to exclude from a dimension in a table an entry where the text includes emergency or unassigned as shown below.
Desired Outcome | |
Engineer | Engineer |
Mike Smith | Mike Smith |
Andrew Smith | Andrew Smith |
Devon Emergency | Gill Smith |
Essex Unassigned | |
Gill Smith |
When I use if(not Match([Engineer],'*Unass*','*Emerg*'),[Engineer]), it returns all 5 engineers.
maybe WildMatch
if(not WildMatch([Engineer],'*Unass*','*Emerg*'),[Engineer])
maybe WildMatch
if(not WildMatch([Engineer],'*Unass*','*Emerg*'),[Engineer])
Thanks for your help Maxgro