topic Validation between collection in Product Forum

Validation between collection

SAINNATHSURAY — Wed, 27 May 2020 13:55:00 GMT

I has Two coll A, B

Coll A has three columns Date , day Volume , Night Volume ,
Coll B had only Date , Volume with both Day and night values ,

now i want check whether all Day and night values present in are available in CollB.Volume for particular or not

------------------------------
SAINNATH SURAY
Business process Lead
TATA CONSULTANCY SERVICE
Asia/Kolkata
------------------------------

RE: Validation between collection

RonanConsidine — Fri, 07 Aug 2020 10:12:00 GMT

Hello Sainnath,

You would be able to do this by using a loop function.

Loop collection A and then use the Collection manipulation utility object and select 'collection contains value' to look for the values in collection B.
You will have to do this three times for [Collection A.Date] and [Collection A.DAY] and [Collection A.Night].

My question would be why do you need to convert this data into this format and then compare them? If you have set up actions to convert Collection A into Collection B you would not need to compare them afterwards.

Hope this helps.

Best Regards,

Ronan

------------------------------
Ronan Considine
------------------------------

RE: Validation between collection

InJoeKhor — Thu, 08 Oct 2020 16:24:00 GMT

Hi Sainnath,

One other way you could do is to create a Queue then send the collection A data to the Queue. Loop through the Queue with collection B, then if they match, process to mark as complected, otherwise keep working.

Hope this helps.

Thanks

------------------------------
In Joe Khor
Sr. Product Consultant
Blue Prism
------------------------------