Check with data 2 file

[fairymemay (noona)]

Hello,
I have 2 file (input , report)

I want to check dup condition as below.

File that describe output (how to check?)
ex.xlsx (296.2 KB)

File data as attached.

input1.xlsx (10.5 KB)
Report.xlsx (492.1 KB)

Please guide me for solve it.
Thank you.

[Yoichi]

HI,

How about the following sample?

Sample
Sample20240314-2.zip (721.7 KB)

Regards,

[fairymemay (noona)]

Thank you for support.

[fairymemay (noona)]

@Yoichi Output correct.

But I have a concern because company policy doesn’t allow using if inside if and actual file report have data 1000 record if take time to run.

Can you recomment for solve it?

Thank you.

[Yoichi]

@fairymemay

company policy doesn’t allow using if inside if

I modified workflow like without If inside if. Can you check the following sample?

actual file report have data 1000 record if take time to run.

I don’t think it takes so long time in run mode if there are around 1000 records in Excel.
However it may be better to use DataTable instaed of ForEachExcelRow to improve throughput.

Sample
Sample20240314-2 (2).zip (721.7 KB)

Regards,