Remove the Rows from one data table who are matching in second datatable

Help Studio
, , , ,
1

Hello All,

I have one scenario where I am having two data tables, A and B as below

A -
image

B-
image

I want to remove all the rows of data table B from A that are exactly matching except the Column Download Status, but the Download Status column must have the value as Success.
Expected Output-
image

Please help me by suggesting any linqquery.

Thanks in Advance.

3

give a try at the following:

Assign Activity:
arrColsA | Datatype: String Array =
new String(){“Process Name”, “Execution Date”, “FileType”}

Assign Activity:
arrColsB | Datatype: String Array =
new String(){“Process Name”, “Execution Date”, “FileType”, “Download Status”}

Assign Activity
dtFiltered =

(From d In dtA.AsEnumerable
Let arrA = arrColsA.Select(Function (x) d(x)).Append("Success").toArray
Where Not dtB.AsEnumerable.Any(Function (d2) arrColsB.Select(Function (y) d2(y)).toArray.SequenceEqual(arrA))
Select r = d).CopyToDataTable

Also have a look here:
:ambulance: :sos: [FirstAid] Datatable: Debug & Analysis invalid DateTime Strings / String to DateTime Parsing Issues - News / Tutorials - UiPath Community Forum

:ambulance: :sos: [FirstAid] Handling of The source contains no DataRows exception - News / Tutorials - UiPath Community Forum

4

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