How to use code stage for Vlookup in two collections?

[GuggsKia]

Hello
I have two collections say col1 and col2. I want to use vlookup as we use in excel. If not clear enough, let me know, I'll give an example too.

------------------------------
Guggs Kia
------------------------------

[NupurSood]

You can download the asset SPGMI - Utility Collection Booster available on digital exchange. It has actions, left join, inner join and outer join which can be used depending on your requirement. 

Best 
Nupur

------------------------------
Nupur Sood
Automation Associate
S&P
Asia/Kolkata
------------------------------

[Vamshi_KrishnaD]

Attached is VBO for vlookup in excel

------------------------------
VamshiKrihsna Dasa
System Architect
Fujitsu India Consulting Pvt. Ltd.
------------------------------

[GuggsKia]

Hi and thanks.
First thing, 
I want to use vlookup in two collections.
Plus how can I use this attached file to create this VBO.
Please help!

------------------------------
Guggs Kia
------------------------------

[NileshJadhavBP]

Hi,

You have to use below methods to matched and get value.

1.Use 2 different loops for 2 different collection ( Nested loop )
2. or you can use filter collection to get exact match result ( Might need to use loop)

Thanks
Nilesh

------------------------------
Nilesh Jadhav
Senior RPA Specialist
------------------------------