Dear Master,
Greetings !!
I am stuck with one problem, wherein i have
Excel A- Input File
Excel B - Matching File.
i was trying to Match Excel A with Excel B with Column “Country”.
if Match found i need an output of all the matched rows from Excel B.
e.g. if country IN has 2 rows in Matching file “Excel B” then i need those two rows in output file.
i was trying with if activity. but i am only getting one row from excel B.
request your assistance on the same.
Thank you so much for your support.
(From r1 In dt1.AsEnumerable
From r2 In dt2.AsEnumerable
can you please explain what is r1 and r2
and will i be able to use this if i need to compare with multiple column.
for example if there is no match found from country then i should try to match with pin.
i have attached the updated excel…
please help Excel A.xlsx (11.5 KB) Excel B.xlsx (9.9 KB)
hi @NIVED_NAMBIAR
one small query.
i want to write this in dynamic way… r1 and r2
can i use column name instead of r1 and r2
because this country or pin can be anywhere in excel
@NIVED_NAMBIAR has shared this earlier with me .
actually m trying to use config file which i have shared with Nived as well…
he has provided me a solution i am trying that…
hi @NIVED_NAMBIAR …
one question is that possible to get “Name” from Excel A + the row items of excel B.
for example the WF which u shared yesterday in output…
please advise