Remove rows from datatable with equal values in two columns

Help Studio
,
1

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

2

@MaciejSartys,

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

General.xaml (9.8 KB)

3

Hi @MaciejSartys,

Use Assign Activity,

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

RemoveDataRows.xaml (8.8 KB)

Thanks!

1 Like
4

Hi @MaciejSartys

dtOutput=dtInput.Defaultview.ToTable(True)

Pls try this.