10-17-2019 12:26 AM
Hi guys,
I am trying to use router with diff data scenarios, where I have to give conditions like:
1)
($DIFF_REC_COUNT<0) && (_PIPELINE_NAME.contains(‘DI_AVT_DH_PERSON_TYPE_ODS’,‘DI_AVT_DH_PERSON_CITIZENSHIP_ODS’,‘DI_AVT_DH_PERSON_LANGUAGE_ODS’))
If its true, goto Success flow or
goto this flow.
But looks like this expression is not correct; hence I am getting error like:
Failure: Unexpected error occurred while evaluating expression: SC@7e0b949, Resolution: Please check your expression
Please suggest!
Solved! Go to Solution.
10-17-2019 03:01 AM
I solved this issue actually…
I gave this exp and it worked.
($DIFF_REC_COUNT<0) && (_PIPELINE_NAME.contains(‘PERSON_TYPE_ODS’)|| _PIPELINE_NAME.contains(‘PERSON_CITIZENSHIP_ODS’)|| _PIPELINE_NAME.contains(‘PERSON_LANGUAGE_ODS’) )
THanks for your quick response though… 🙂
10-20-2022 05:13 AM
Wrap the whole expression in parenthesis and a NOT operator:
!($field002 matches "88017"|"88067")
10-20-2022 06:12 AM
perfect. these little easy syntax cannot be found in the documentation! the hard ones, yes.