How to filter datatable with result of two column

Help Activities
, ,
1

Hi,
I have datatable like picture below
image

I wanna get only row where column2 - column3 <> 0
So how could i get the row i want? please help
Thanks

2

Hi @ThomasTH

You can try with Filter Data Table activity

image
image746×384 18.4 KB

Check out the Blog

Regards
Gokul

3

You Can also try with this LINQ expression @ThomasTH

DTInput.AsEnumerable.Where(Function(r) Not ((r(0).ToString).Equals("0") OrElse (r(1).ToString).Equals("0"))).CopyToDataTable

Regards
Gokul

4

Try the filter datatable activity as shown below in the image

image

5

HI @ThomasTH

Check out the XAML file

DtNotContainZero.xaml (7.3 KB)

image

Regards
Gokul

1 Like
6

Hi Gokul,

Thanks for reply but that not what i means
i means like example in my picture, Smith have value in column 2 is 15 & column 3 is 14
So i’m gonna do column 2 minus column 3 and i’ll get result is 1.

So my question is how could i get new datatable where data row which the rows has column2 minus column3 <> 0 ?

7

Try with this expression to Sub @ThomasTH

CDbl(CurrentRow(0).Tostring) - CDbl(CurrentRow(1).Tostring)
1 Like
8

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