Different Duplicate Scenarios of Comparing Between Two(2) Data Tables Using Linq

Help Activities
, ,
1

Good day UiPath Community,

Is possible to implement these three(3) scenarios in ONE set of LINQ code?

I have 3 scenarios for Duplicate Rows of Comparing between Two Data Tables

• First, a scenario with the same DUPLICATE key column “Unique Identifier” matching from DT1 to DT2 and store it on output MatchedDT.

• Second, a scenario comparing “Unique Identifer” column of DT1 to DT2 but DT1 has multiple DUPLICATE “Unique Identifier” rows. There is a separate output for the DUPLICATE rows in DT1.

• Third, a scenario comparing “Unique Identifer” column of DT2 to DT1 but DT2 has multiple DUPLICATE “Unique Identifier” rows. There is a separate output for the DUPLICATE rows in DT2.

Refer to the Data Tables below for visual reference:

image
image1433×517 19.3 KB

1 Like
2

Hey @anthonyjr

Could you please share the sheet itself ?

Thanks
#nK