Get max value from extracted datatable

[Anil_Potekar]

I have statement data in datatable using screen scraping all column in string data type, I want to get max debit entry from debit column with remaining balance from bal. Column.
I write extracted datatable in Excel shows number stored as text.
Due to this I’m not able to find max value from debit column.
Please give the solution…

[arivu96 (Arivazhagan A)]

HI @Anil_Potekar ,

Refer below link for datatable any operations

All about Datatable - UiPath

Hi All, Datatable - variable type is the most commonly used variable type by all UiPath users And it’s been the most often asked queries in forum especially on its manipulation So I would like to have this post as a repository for those who are looking for expressions related to Datatable Let’s go one by one keeping dt as name of datatable variable 1. Get number of rows in a datatable dt dt.Rows.Count (output - int32 type) 2. Get number of columns in a datatable dt dt.Columns.Count (output…

Regrads,
Arivu

[Shikhar_Tandon]

Hi @Anil_Potekar

Can you please give some examples of the data.

Thanks

[Anil_G (Anil Gorthi)]

@Anil_Potekar

1.Either change the column type in datatable to double

Or

When needed try converting the string to number and then use in formula

Cheers

[Anil_Potekar]

[Anil_G (Anil Gorthi)]

@Anil_Potekar

Use = text(number,“000.00”) second is the format then you wont get the error

Or as said earlier try changing the datataype in datatable or in the excel

Cheers

[balupad14 (Balamurugan)]

Hi @Anil_Potekar ,

Can you try this one.

simple solution
maxVal= dt.AsEnumerable.Max(Function (y) CDbl(y(“debit”).toString.Trim))

Detailed solution

Anil_Potekar.zip (80.0 KB)

Regards
Balamurugan.S