Help needed regarding matching or comparison between sheets

[wen_qiang]

Hi all, I am currently working on a workflow to compare two sheets.

SheetA: contains keywords
SheetB: contains chunk of words
my goal is to look for keywords contained in sheetA in sheetB just like how ctrl f works in excel. if the keyword existed in sheetA, i will extract information from both sheets and store them in a new sheet.
i used two for each row activities and have tried the formula indexof in this form:
line.item(2).tostring.indexof(line.item(1).tostring) >=0
the former represents the row in sheetB and the latter represents the keyword in sheetA.

however, the method did not extract out the information correctly and completely.

I really need help on this as assignment dateline is approaching and i have searched up and down for solution on google but none works. i have attached my workflow together with the sample file that i am working on. i would really appreciate for your kind attention and help (32.0 KB)

[Nithinkrishna]

Sorry @wen_qiang,

I can’t able to download your file. Could you please upload the project and supporting files once again please.

Awaiting your response.

Thanks

[wen_qiang]

sorry about that, i upload again.Main.xaml (9.8 KB) Sample.xlsx (35.4 KB)

[Steven_McKeering]

Hello

Does this video help?

UiPath: How to compare two Data Tables

[Nithinkrishna]

No problem @wen_qiang,

I had a look at the workflow. There was a small issue with the search comparison logic.

Modified the same, hope it works as expected now.

PFA - ExcelComp.zip (33.3 KB)

Kindly confirm.

Thanks

[wen_qiang]

Thank you Steven, I will watch the video.

[wen_qiang]

Hi @Nithinkrishna ,

Thank you so much for helping me out with the workflow, i have tried it but the output i got is incorrect such that the the keyword is not found in SheetB even though the row index search indicated the number.

[Nithinkrishna]

@wen_qiang, Could you please tell me which row value is wrong in results sheet.

Will have a look, Thanks

[wen_qiang]

Hi, @Nithinkrishna this is the result i have generated but after checking, the keyword is not found in sheetB even though the serial number is indicated.Sample (1).xlsx (35.8 KB)

[Nithinkrishna]

@wen_qiang, Kindly check now and confirm. Optimised a bit.

PFA - ExcelComp_updated.zip (66.2 KB)

Thanks

[wen_qiang]

Thank you so much! @Nithinkrishna, ur help is greatly appreciated!