Compare two datatables and keep only the values from one dt

[najoua.abbaci (Najoua A.)]

Hello everybody,

I need help !
I have two datatables. One master datatable (dt1) with all the items and values : like following

And I have a second datatable (dt2) with values that I have to remove from the master Datatable

Basically, I need to remove the list of “groupe marchandises” (dt2) from the list of the Master Datatable (dt1).
If I am not clear, tell so i can be more precise.

I tryied with a lookup datatable activity, but not sure that it is the right activity to do so.

Can anyone help me out please ?

maybe @ppr @Parth_Doshi can help please ?

Thank again for taking time !

Regards

Najoua

[ppr (Peter Preuss)]

@najoua.abbaci

Give a try on

Assign Activity
Left Side dtfiltered datatype:datatable
Right side

(From d in dt1.asenumerable
Where Not dt2.asenumerable.any(function (x) x(1).toString.trim.equals(d(0).toString.trim))
Select d).copytodatatable

Expect some typos or wrong (. ). As my Cellphone Tries to pair programming with me and Breaks the Code

IT should keep the row from dt1 when the Code is Not found on any row in dt2

Let US know If IT was working thanks

[najoua.abbaci (Najoua A.)]

@ppr

(From d in dt1.asenumerable
Where Not dt2.asenumerable.any(function (x) x(1).toString.trim.equals(d(0).toString.trim))
Select d).copytodatatable

Thank you very much it is working perfectly !!!