Expand my Community achievements bar.

Join us on September 25th for a must-attend webinar featuring Adobe Experience Maker winner Anish Raul. Discover how leading enterprises are adopting AI into their workflows securely, responsibly, and at scale.
SOLVED

Function in condition node not worked well

Avatar

Level 4

chrisyan_0-1740579881132.png

I am using "notin" function to exclude not needed data from array column but having errors.

 

please advise

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

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

View solution in original post

6 Replies

Avatar

Employee Advisor

You will have to use it on the following lines

 

not(

in(#{ExperiencePlatform.ProfileFieldGroup.profile.person.gender}, ["male"]))

 

https://experienceleague.adobe.com/en/docs/journey-optimizer/using/orchestrate-journeys/building-adv... 

Avatar

Level 4

chrisyan_0-1740581393007.png

Thank you, but still error out

Avatar

Correct answer by
Employee Advisor

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

Avatar

Level 4

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 

Avatar

Employee Advisor

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

Avatar

Level 4

Make sense. Thanks so much for it.