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?
It will be much faster to do this with a C# script. You can use Pega Robotics and the Excel connector to extract the columns into DataTables (the ExportData method of the connector) and then pass those DataTables into your C# script to do the comparison and evaluation. This is possible using solely the connectors, but it will be noticeably slower. If you have enough C# knowledge to work with DataTables, then I would pursue that as it will certainly be much faster.