Filter 2 excel and merge together

hi, I understand the logic, but I couldn’t make it work. anyone mind helping?
Appreciate!!!
__


img1: special request
img2: main report
img3: wanted result
__
from img1 filter those with request contain “email”
then compare “donor id” from img1 with “dnr_id” from img2
finally write it into a new excel ‘rptDup’. the result should be like img3
__
filterDatatable.zip (26.3 KB)

hey @terrylim11
can i have the excel files

it is inside the zip file

Sequence.xaml (10.1 KB)
hey @terrylim11
Kindly check this workflow.Hope this helps.
Mark as solution if it works.

1 Like

@terrylim11

Hope this workflow helps!!
transfermail.zip (60.4 KB)

1 Like

it works like charm. this is easier to understand! tqvm and love u

1 Like

tqtq. it works. very detailed

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