How to compare 2 Datatable and remove the uncommon rows

Help Studio
, ,
1

Hi, I want to compare 2 datatable and remove the uncommon rows and keep the duplicate and new records.
and the output should be like
name PO item no Status Update
Bosch P29485 i5423 not shipped
Bosch P20230 i8756 Done
Bosch P99432 i0923
Bosch P22310 i6109

old data.xlsx (8.5 KB)
new data.xlsx (9.4 KB)

2

Hopefully you will get some ideas out of it.

3

Hi @ahmed4566

In New Data there is two sheet which sheet is used to comapre with Old data ?
And can you share the expected output as well

4

in new data xlsx file …sheet2 will be compared with old data

5

Read Range both into separate datatables then do a Join Data Table set to inner.

6

Thanks …I will try and come back to you

7

its not creating the correct output by using this logic

8

Closing this problem as I didnt receieve any solution on it

9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.