Get common/uncommon rows based on some columns from datatable

Help Studio
, , , , , ,
1

Hi Community,

Require some help on below scenario

I have 2 Datatables named DT1 and DT2.
I want to match some columns of the data between those two tables If data match I want two outputs 1. The matched records, 2. The unmatched records

I have attached Input and Output for same. In the Input file Sheet1 and Sheet2 can be referred as DT1 and DT2 and the columns to be compared are “Server” and “Value”.

Output file contain 2 sheets → matched and unmatched

Imp - matching is done only on the above mentioned columns based on them match/not match the row item is to be picked and accordingly printed in the output

Input.xlsx (9.8 KB)
Output.xlsx (9.5 KB)

Help appreciated.

Thanks!!

2

find starter help here:
FindMatchesNonMatches_ColSetCheck_SequenceEquals_V2.xaml (15.3 KB)

3

Hi @ppr

Thanks a lot for this quick reply.
Can you explain a bit about what is happening in the code and how can I get my result.
I saw the code but I am not sure that much.

Thanks!!

4

I would suggest you look at the Join activity.

Inner join to find rows that match.
Left join to find rows that only appear in one table

You will end up with out_TableOfMatches and out_TableOfNoMatches. Then process as necessary.