Help needed regarding matching or comparison between sheets

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|attachment (32.0 KB)

1 Like

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

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

1 Like


Does this video help?

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 - (33.3 KB)

Kindly confirm.

Thanks :slight_smile:

Thank you Steven, I will watch the video.

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.

1 Like

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

Will have a look, Thanks :slight_smile:

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)

1 Like

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

PFA - (66.2 KB)

Thanks :slight_smile:

1 Like

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

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.