Comparing Collection fields with Exel fields

[RobTech116]

Hi,
Can someone share the thoughts on how to solve below query:

I have some data in a collection and an excel sheet.
I need to compare the values of collection field with the values in Excel sheet.
Like the first value in my collection should search entire column of excel to find its duplicate.
And second value in my collection should search entire column of excel.

Thanks in advance!!

------------------------------
Shah 116
------------------------------

[LakshmiNarayan3]

Hi Shah,

this is based on my understanding of your query ,

Loop collection in loop try OLEDB to fetch the data ( Duplicates in column ) with the condition of values in column in excel.

Hope this is is you are looking for.

Regards

------------------------------
Lakshmi Narayana
------------------------------

[ManpreetKaur1]

Hi @RobTech116,

Did you try using vlookup in excel to achieve your results?

It can easily be achieved using vloopup functionality and then filtering out the results which are duplicate in nature. Please let me know if you need any help in creating the vlookup query.​​

------------------------------
Manpreet Kaur
Manager
Deloitte
*If you find this post helpful mark it as Best Answer
------------------------------