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-17-2019 03:10 AM
Great, issue was passing multiple arguments in contains fucntion.
10-17-2019 03:11 AM
u r right!
10-19-2022 08:08 AM
I have seen some solutions here but nothing that is working for me. Here is my issue:
Looking all thru the expressions library for info on MATCH or CONTAINS I cannot find the right syntax to find this. How do you pull in multiple arguments?
$field002 in (“88017”,“88067”)
this works:
$field002 ==“88017”
how do i say IN (blah blah)
and NOT IN (blah blah)
I am used to sql expressions not Java.
10-19-2022 11:23 AM
Try the following expression:
$field002 matches "88017"|"88067"
10-20-2022 05:08 AM
that worked but how do you say does not match? i tried ! and a few different ideas. kept getting errors