Find Min value from datatable

Hi Everyone.
Have a nice day!

I have DataTable after scrapting on the web .

How to find MIN value from datatable without sorting as below picture?

Thanks you!
1

Hi @trunghai

Check this

Int MinValue=Convert.ToInt32(dt.AsEnumerable().Min(Function(row) row(“Column1”)))`

Thanks
Ashwin.S

3 Likes

Hi @AshwinS2

Thanks you so much.

But in XAML file, it shown the result “14000” …

Is there any incorrect in my XAML file ?

Hi @trunghai,
1.It will be in string format so first convert them into int and perform the activities.
Cheers.

1 Like

Hi @Vashisht

Thanks you but I think it was converted by this command : Int MinValue=Convert.ToInt32(dt.AsEnumerable().Min(Function(row) row(“Column1”))) ?

How to do convert string into int by your way ?

I will just split the string using space and convert into int and find the min value.
We can easily find min value if there are array of integers.
Cheers.

1 Like

Hi Bro @Vashisht

Could you pls suggest me the way to convert my datatable as above into Int?

Thanks you !

1.Use output data table activity it will give string.
2.split the string with newline character.
3.Then convert each to int and then check for min value.
Cheers

1 Like

Thanks you bro.

I’m trying but I don’t know exactly to do it.

Did you get it bro?

Hi bro.

Still not yet.
I have used this command but it has something wrong.
Int MinValue = (From p In dta.select() SelectConvert.ToInt32(p(“Value”))).ToList().Min