How to get a line from Table with highest number in column A ?

[mikakojonkowski]

How to get a line from Table with highest number in column A ?


1|test1
2|test2
3|test3

output= 3|test3

 

[lokiys]

How to get a line from Table with highest number in column A ?


1|test1
2|test2
3|test3

output= 3|test3

Moved your question. Please use right sections for questions.
Thanks

 

[Adigen]

You can use this little c# snippet:

var table = project.Tables["Table 1"];
var list = new List<int>();
for (var i=0;i<table.RowCount;i++) {
    list.Add(Convert.ToInt32(table.GetCell(0,i)));
}
return string.Join(table.ColSeparator,table.GetRow(list.IndexOf(list.Max())));

 

[mikakojonkowski]

You can use this little c# snippet:

Thank you, works awesome. Heres edited to return just cell 0 value:

var table = project.Tables["forms"];
var list = new List<int>();
for (var i=0;i<table.RowCount;i++) {
    list.Add(Convert.ToInt32(table.GetCell(5,i)));
}
return string.Join(table.ColSeparator,table.GetCell(0, list.IndexOf(list.Max())));

 

[Tobbe]

Snippet to determinate what variable got the lowest value

 

[Adigen]

Thank you, works awesome. Heres edited to return just cell 0 value:

var table = project.Tables["forms"];
var list = new List<int>();
for (var i=0;i<table.RowCount;i++) {
    list.Add(Convert.ToInt32(table.GetCell(5,i)));
}
return string.Join(table.ColSeparator,table.GetCell(0, list.IndexOf(list.Max())));

if you need to return only cell 0 value, you can use

return list.Max()

 

[mikakojonkowski]

if you need to return only cell 0 value, you can use

return list.Max()

Yes thank you