How to find the highest value in a CSV file

[aksh1yadav (AKSHAY YADAV)]

Well @sharks14

@sharks14

and find the highest value in a column and save the date that this value is for. I use a sequence and read csv activity, but am stuck from there. Should I use an assign activity and then a for each activity?

You can try @sfranzen way as well but i have also one more way to do this

@sharks14

Should I use an assign activity and then a for each activity?

No need to use for each for this

You can get the highest column value for “Close” Column like this

Int maxval = Convert.ToInt32(data.Compute("max([Close])",String.Empty))

one more way is Datatable.select() as @sfranzen mentioned.

there one more is to use IEnumerable.max method as well

String maxval = datatable.AsEnumerable().Max(Function(r) r("Close")).ToString

Feel free to use any one of them.

and if you wants to fetch the date as well from the max close amount row.

try this :
(Datatable.Select(“[Close]='”+ienumerable_Datarow.Max(Function(r) r(“Close”)).ToString+“'”))(0)(0).ToString

This is the first thing came into mind. @andrzej.kniola you can add more things i guess haha

sample_shark.zip (3.0 KB)

Regards…!!
Aksh