Filter Datatables

[juergenh1975]

Hello,

I need a datatable filter that I can not implement. please help me.

I have a dt1 and a dt2, at the end the data from dt1 should remain if they are not contained in the dt2.

I hope I could explain it so you understand it

[Sudharsan_Ka]

Hi @juergenh1975
Can you share the excel?

[ppr (Peter Preuss)]

@juergenh1975

use an assign activity
left side: dtResult | Datatype: datatable
Right side:

(From d in dt1.AsEnumerable
Where Not dt2.AsEnumerable.Any(Function (x) x(“NR”).ToString.Trim.Equals(d(“NR”).toString.Trim))
Select d).CopyToDataTable

[juergenh1975]

why excel share ?
my Excel screen should only show as an example

[juergenh1975]

thank you very much, but sorry I’m a beginner.
can you please give me the exact value I have to enter on the right

[Sudharsan_Ka]

@ppr

From d in dt1.AsEnumerable
Where Not dt2.Any(Function (x) x(“NR”).ToString.Trim.Equals(d(“NR”).toString.Trim))
Select d).CopyToDataTable

@juergenh1975 This is the Whole Value you need to enter in right

[ppr (Peter Preuss)]

[juergenh1975]

Thank you so much! unfortunately I can only check it tomorrow morning, but I am confident that it works

[ppr (Peter Preuss)]

In case of we have to assume that also an empty result can occur (all dt1 rows are present in dt2) we would handle it like following to avoid an exception thrown by CopyToDataTable.

Vars:

Flow:

[juergenh1975]

the first suggestion worked wonderfully! Thanks very much !

which variable type is your “Result” exactly? I can’t find “List-DataRow-”

[ppr (Peter Preuss)]

then confirm with OK, OK

[juergenh1975]

now it’s perfect! and thank you again!