kowsalyav1404 Member since 2017 15 posts
Posted: March 31, 2019
Last activity: April 3, 2019

Excel Operations

Hi team,

i have a requirement to compare 3 columns nearly for every row in Excel1 with the Excel2. I may have 100's of records in both excels.We have to return the required relative information for the matched/partially matched row in Excel2 even if one of the 3 columns matches or even all of them match with Excel1.

Kindly suggest if i can achieve this only using nested for loops or will queries help and how so that i can make it quick enough? My only motive of the BOT is to compare based on the combination of those 3 columns and i think using looping will slow down?

Robotic Process Automation
Moderation Team has archived post
Share this page LinkedIn