WildMatch and If statement

[joshakehurst]

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]) 

[marcus_sommer · Accepted solution]

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