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 ?

@MaciejSartys,

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)

Thanks!

1 Like

Hi @MaciejSartys

dtOutput=dtInput.Defaultview.ToTable(True)

Pls try this.