Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm having a mental block today on WildMatch parameter. Any suggestions on how to write an expression to EXCLUDE a userID prefix from a data set. I assume I could use a <> parameter, but can't figure it out.
Example to include anything 'Test*' but would like to exclude test from the data set.
if(WildMatch([UserId],'Test*'), [UserId])
It's not quite clear for me what do you are meaning with "exclude test from the data set"? Here a variance to your expression which might be more suitable:
if(not WildMatch([UserId],'Test*'), [UserId], null())
- Marcus
It's not quite clear for me what do you are meaning with "exclude test from the data set"? Here a variance to your expression which might be more suitable:
if(not WildMatch([UserId],'Test*'), [UserId], null())
- Marcus