topic RE: Comparing Collection fields with Exel fields in Product Forum

Comparing Collection fields with Exel fields

RobTech116 — Fri, 28 Oct 2022 13:04:00 GMT

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
------------------------------

RE: Comparing Collection fields with Exel fields

plnarayana777 — Sat, 29 Oct 2022 10:52:00 GMT

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
------------------------------

RE: Comparing Collection fields with Exel fields

ManpreetKaur1 — Mon, 31 Oct 2022 20:13:00 GMT

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
------------------------------