topic RE: Lookup in Collection in Product Forum

Lookup in Collection

paul_tudberry — Thu, 28 Nov 2019 09:41:00 GMT

HI Guys, apologies if this has been asked previously, I have 2 matching collections with identical field names, I wish to lookup if a value exists in a certain field and return a true/false answer without looking through the full collection.

For example

the Value in [Collection1.Field1] = "Dave"

Collection 2 could have 50 names in it, I wish to see if any of the values in [Collection2.Field1]="Dave" without looping through the full collection.

------------------------------
npower
Europe/London
------------------------------

RE: Lookup in Collection

JeroenOosterhol — Thu, 28 Nov 2019 11:42:00 GMT

You can use action "Collection contains value" from the Utility - Collection Manipulation to check whether a value occurs in a collection

------------------------------
Jeroen Oosterholt
Automation Designer
DHL
Maastricht
------------------------------

RE: Lookup in Collection

AndreyKudinov — Thu, 28 Nov 2019 12:03:00 GMT

Or filter collection 2 by that value and see if result set contains data.

------------------------------
Andrey Kudinov
Project Manager
MobileTelesystems PJSC
Europe/Moscow
------------------------------

RE: Lookup in Collection

paul_tudberry — Thu, 28 Nov 2019 15:58:00 GMT

Great , thank you guys,

------------------------------
npower
Europe/London
------------------------------