Check duplicate?

[fairymemay (noona)]

Hello,
I have 2 file (input , report)

I want to check dup condition as below.

1. Check Dup
   1.1 Check dup column SR# in file input or not If dup stamp Y in column Check Dup
   1.2 Check dup with file report if match column SR and column Activity check column Closed Date file report have text or not
   1.2.1 If text = “working” or blank ----> stamp N in column Check Dup
   1.3 Check dup with file report if match column SR → check column Closed Date file report have text or not
   1.3.1 If text = “working” or blank ----> stamp Y in column Check Dup
   1.3.2 If text <> “working” but have value ----> stamp N in column Check Dup

Please guide me for solve it.
Thank you.

@Jayesh_678

input1.xlsx (10.5 KB)

Report.xlsx (492.1 KB)

[fairymemay (noona)]

Anyone can guide me for solve this case?

Thank you.

[ppr (Peter Preuss)]

the description can not fully be matched to the sample data. Can you please cross-check? Thanks

[fairymemay (noona)]

I updated file and condition completed.

[fairymemay (noona)]

I know condition is complex.
So I create flow for describe condition.

Please guide me for solve it. @Yoichi @Anil_G

Thank you.