Passing multiple values using single runtime parameter variable.
eg: cmpy_code variable should contain values like A123, B456, 0C56...etc
which can be accessed through runtime parameter in a pipeline.
Similar to IN operator in DB.
Passing multiple values using single runtime parameter variable.
eg: cmpy_code variable should contain values like A123, B456, 0C56...etc
which can be accessed through runtime parameter in a pipeline.
Similar to IN operator in DB.
You can pass them with a separator and within your processor stage you can use them accordingly. Or if A123, B456, 0C56 values are part of a record and you want to send these as a parameter by Start Jobs processor then you can use code or Expression evaluator to create a single string and then pass this to the called Job.
Below screen-shots for your reference as suggested by
Hi
can you please suggest an approach for reading the same data1 variable (having multiple values, separated by comma) by using expression evaluator.
I need to verify, whether the input record flowing from source contains any one of the data present in data1 variable.
Here is a way to do this
Dev Data Source has a field called f1 with a value of ‘abc’
I have created a parameter called data1 with value 0000;abc;1234;defg;3244;2222
Use Expression evaluator to split the parameter to a list of values
Add Javascriot evaluator and following code
var matchFound = false;
for (var j = 0; j < recordsli].value.split.length; j++) {
if (recordsii].value.splitvj] === records=i].value.f1) {
matchFound = true;
break;
}
}
The output looks like this
If i change the parameter to 0000;abcd;1234;defg;3244;2222. I get false
I hope it helps.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.