ruchi_pandey
New Contributor II
Joined 7 years ago
User Profile
User Widgets
Contributions
Code re usability
Hi All, I have one requirement, where in I have to use the similar flow of snaps in most of the pipelines. Example–> To load person data, I will follow the steps like Insert entry in module_table–> fetch data from oracle table–> load data to a diff oracle table → Update the module_table I am using this same flow in almost 14 pipelines. And in future the count of such flow would be ~90. SO I was thinking to find a way out to reduce the effort of creating a new flow, and use a common flow and then it can be re-usable. Please share your thoughts. Thanks.2.2KViews0likes1CommentRe: How to use "contains" function in router? I am getting error of expression failure
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… 🙂7.9KViews0likes2CommentsRe: How to use "contains" function in router? I am getting error of expression failure
I gave this in Expression: ($DIFF_REC_COUNT<0)==true && (_PIPELINE_NAME.contains(‘PERSON_TYPE_ODS’,‘PERSON_CITIZENSHIP_ODS’,‘PERSON_LANGUAGE_ODS’,‘OCF_US_ODS’,‘OCF_MEXICO_ODS’,‘OCF_NETHERLANDS_ODS’,‘OCF_COSTA_RICA_STG’)==true) And got this error… JSON o/p [ { “reason”: null, “failure”: “Unexpected error occurred while evaluating expression: SC@3ce966fb”, “resolution”: “Please check your expression”, “sub-expression”: { “0: $DIFF_REC_COUNT”: [ -2 ], “1: 0”: , “2: <”: [ true ], “3: true”: , “4: ==”: [ true ], “5: _PIPELINE_NAME”: [ “DI_AVT_DH_OCF_COSTA_RICA_STG” ], “6: ‘PERSON_TYPE_ODS’”: , “7: ‘PERSON_CITIZENSHIP_ODS’”: , “8: ‘PERSON_LANGUAGE_ODS’”: , “9: ‘OCF_US_ODS’”: , “10: ‘OCF_MEXICO_ODS’”: , “11: ‘OCF_NETHERLANDS_ODS’”: , “12: ‘OCF_COSTA_RICA_STG’”: , “13: (‘PERSON_TYPE_ODS’,‘PERSON_CITIZENSHIP_ODS’,‘PERSON_LANGUAGE_ODS’,‘OCF_US_ODS’,‘OCF_MEXICO_ODS’,‘OCF_NETHERLANDS_ODS’,‘OCF_COSTA_RICA_STG’)”: [ { “_snaptype_arguments”: { “searchString”: “PERSON_TYPE_ODS”, “position”: “PERSON_CITIZENSHIP_ODS”, “ignored”: “OCF_COSTA_RICA_STG” } } ] } } ]4.4KViews0likes4CommentsHow to use "contains" function in router? I am getting error of expression failure
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 ($DIFF_REC_COUNT<0) && (_PIPELINE_NAME.contains(‘DI_AVT_DH_PERSON_TYPE_STG’,‘DI_AVT_DH_PERSON_CITIZENSHIP_STG’,‘DI_AVT_DH_PERSON_LANGUAGE_STG’)) 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!Solved9.6KViews0likes11Comments