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 …

HI @Anil_Potekar , Refer below link for datatable any operations [image] All about Datatable - UiPath Tutorials 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 …

Hi @Anil_Potekar Can you please give some examples of the data. Thanks

@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

[16726492784128597809888086656963]

@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

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

Get max value from extracted datatable

Help Activities

arivu96 (Arivazhagan A) January 2, 2023, 7:26am 2

HI @Anil_Potekar ,

Refer below link for datatable any operations

Regrads,
Arivu

Topic		Replies	Views
Maximum value of a datatable row StudioX studiox , question	17	5097	November 15, 2021
Find Maximum Value in the column Help datatable , excel	6	7632	July 3, 2020
How to get max value from datatable having string column datatype RPA Discussions datatable , activities , studio , question	8	2383	January 1, 2023
Find Max value from datatable Help datatable	54	27045	December 19, 2021
Find the Maximum value in a Datatable column Studio studio , question , activities_panel	10	3857	May 19, 2023

Get max value from extracted datatable

Related topics