Remove rows from datatable with equal values in two columns

I have datatable with two columns with dates. How can I find/remove rows where those two columns have the same value ?


You can use below attached workflow which deletes matching row by comparing two cols.

General.xaml (9.8 KB)

Hi @MaciejSartys,

Use Assign Activity,

dtInput = dtInput.Select("[A] <> [B]").CopyToDataTable

RemoveDataRows.xaml (8.8 KB)


1 Like

Hi @MaciejSartys


Pls try this.