How do I optionally save a custom data output to an array? A script task custom

greggl over 9 years ago

How do I optionally save a custom data output to an array? A script task custom Data Output requires a target output, so if I try and use an if conditional like this: if(pv!newStaff.hireDate > today(),pv!newStaff.firstName,{}), I end up with a array index of blanks, when I really want no array index added. I want to be able to only add to array index if condition is met but as target output is required, it's saving a blank rather than do nothing as desired.

How can this be done?

Thanks

Discussion posts and replies are publicly visible

Parents

0 nileshr over 9 years ago

You can make a rule for removing a value from a particular index of an array(let's say rule!RemoveValue) with the following definition:

remove(ri!YourOutputVariable,ri!ValueToRemove)

After that, you can call the above rule in another rule like this:

apply(rule!RemoveValue,{wherecontains(null,ri!YourOutputVariable)},ri!YourOutputVariable)

Now, you can use this rule to filter null values from your array.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 nileshr over 9 years ago

You can make a rule for removing a value from a particular index of an array(let's say rule!RemoveValue) with the following definition:

remove(ri!YourOutputVariable,ri!ValueToRemove)

After that, you can call the above rule in another rule like this:

apply(rule!RemoveValue,{wherecontains(null,ri!YourOutputVariable)},ri!YourOutputVariable)

Now, you can use this rule to filter null values from your array.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data