topic Re: find specific value from collection 1 to collection 2 in Product Forum

find specific value from collection 1 to collection 2

LorenzoCapocci1 — Fri, 10 Sep 2021 19:07:38 GMT

Hi Team, as per example below I need to check if items from collection1 are within collection2 but in collection2 we may find more than 10 results...
At the moment I have set to collection to check for duplicate values, but if the below happens, I need to make sure that I don't get the error (now row exist in collection), so it can check and see if any of the items from collection1 are within collection 2, and move thematching item into a new collection

can you help to find an example to follow?
note from collection 1 there will be no empty row to fill up
thank you

Collection1		Collection2
Form1		Form2
GI13289312		GI13289305
GI13289313		GI13289306
		GI13289307
		GI13289308
		GI13289309
		GI13289310
		GI13289311
		GI13289312
		GI13289313

Re: find specific value from collection 1 to collection 2

VedSengupta — Sat, 11 Sep 2021 04:12:59 GMT

Hello Lorenzo,
Why not use a filter collection action followed by a decision stage to check existence of item in Col1 in Col2?

For Example, Let us take your collections above and then the below Steps :

Step 1 : Loop Through collection 1.
Step 2 : Filter item of Col1 in Col2 and store in a temporary Collection --> [col2.field]='[col1.field]' { Stored in Temporary Collection. Let us call it Temp}
Step 3: Check number of rows of Temp.
if Temp>0
element of Col1 exists in Col2
else
element of Col1 does not exist in Col2
Step 4 : Clear Collection Temp for next iteration.
Step 5: Increment counter in Col1 Loop and start Step 1 unless collection end is reached.

Best Regards,
Ved Sengupta
RPA Developer
Deloitte India (Offices of the US)
Bangalore

Re: find specific value from collection 1 to collection 2

LorenzoCapocci1 — Sat, 11 Sep 2021 11:07:00 GMT

Hello @Ved Sengupta, thank you for helping on this, but I would like to ask if it is possible to have an example of this, as I am still new on RPA, and this would help me a lot, if you could do that.. especially with the code you have provided... Thank you very much

Re: find specific value from collection 1 to collection 2

LorenzoCapoccia — Mon, 13 Sep 2021 19:54:28 GMT

Hi @Ved Sengupta, got it to work. thank you

Re: find specific value from collection 1 to collection 2

VedSengupta — Tue, 14 Sep 2021 01:23:12 GMT

Hello Lorenzo,
I have got an query.

In Loop Collection2
Immediately after starting the nested Loop you are checking a decision stage followed by some action.
What value in decision stage are you exactly checking? And From which action are you getting that Value?

Best Regards,
Ved Sengupta
RPA Developer
Deloitte India (Offices of the US)
Bangalore

Re: find specific value from collection 1 to collection 2

LorenzoCapocci1 — Thu, 30 Sep 2021 12:01:27 GMT

Hello @Ved SenguptaThank you for your support, and, I need to apologize for the delay in answering... so this take reference from value read in order to check if value exist in the collection 2 Image Data! so i can go ahead and make a compare action