Take common rows from a DataTable and uncommon from another DT

Help Studio
,
1

Hi, i’m facing the following issue.

I’ve 2 data tables:

A B C D
Jordan Lebron Kobe
Messi Ronaldo Haaland
McGregor Khabib Jones
Oliveira Johnson Cejudo
Makhacev Adesanya Ngannou

and

A B C D
Jordan Lebron Kobe Basket
Messi Ronaldo Haaland Footbal
Jones McGregor Khabib MMA

My goal is to obtain a DT like this

A B C D
Jordan Lebron Kobe Basket
Messi Ronaldo Haaland Football
McGregor Khabib Jones MMA
Oliveira Johnson Cejudo MMA
Makhacev Adesanya Ngannou MMA

Like, “if you don’t find common rows, follow the last info of the 2 DT”.

Hope i well explained my issue.

Cheers
Leonardo

2

Hi @leonardo961900,

PFA the test workflow. Check if it solves your problem.

Test.zip (4.0 KB)

Regards,
Chintan Salvi

3

Hi,

Hope the following sample helps you.

image
image889×1314 41.7 KB

Sample20221117-2.zip (3.4 KB)

Regards,