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.
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 < records[i].value.split.length; j++) {
if (records[i].value.split[j] === 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 username or e-mail address. We'll send you an e-mail with instructions to reset your password.