I am using "notin" function to exclude not needed data from array column but having errors.
please advise
Solved! Go to Solution.
Views
Replies
Total Likes
can you switch the parameters in the function ? second parameter will be a listString and the first one will be a string
not(in( 'DFC', <ListString> ))
You will have to use it on the following lines
not(
in(#{ExperiencePlatform.ProfileFieldGroup.profile.person.gender}, ["male"]))
Views
Replies
Total Likes
Thank you, but still error out
Views
Replies
Total Likes
can you switch the parameters in the function ? second parameter will be a listString and the first one will be a string
not(in( 'DFC', <ListString> ))
so liststring is the position of column and first parameter is the value I would match to from liststring. what if I have more than 1 value to check. what's syntax
Views
Replies
Total Likes
listString will be your array xdm path and you are comparing the first parameter against the whole array (listString). If you need to check for non existence of more than one value, you can use the following syntax
not(in( 'DFC', <ListString> )) and not(in( 'XYZ', <ListString> )
Make sense. Thanks so much for it.
Views
Replies
Total Likes