Enoch_Foul
New Member
Hi
I would like to create a Filter Collection action that will split an input collection and provide the filtered results based on the filter criteria and then a separate collection that outputs all the records that did not match.
For Example:
Collection In:
Filter Criteria: Colour = "Yellow"
Output Collection 1:
Output Collection 2:
Any ideas how this could be done at code stage?
Thanks
I would like to create a Filter Collection action that will split an input collection and provide the filtered results based on the filter criteria and then a separate collection that outputs all the records that did not match.
For Example:
Collection In:
Item | Colour |
Banana | Yellow |
Car | Green |
Doll | Blue |
Bell | Yellow |
Filter Criteria: Colour = "Yellow"
Output Collection 1:
Item | Colour |
Banana | Yellow |
Bell | Yellow |
Output Collection 2:
Item | Colour |
Car | Green |
Doll | Blue |
Any ideas how this could be done at code stage?
Thanks