Get the value that has the max count - via script Load

[Anonymous]

Hi all,

I've attached an app sample.

I have a table with two columns.

I want, VIA SCRIPT LOAD, to get the "Value" that has the max count.

Example:

Value 5 - count = 3

Value 7 - count = 2

Value 9 - count = 1

I want to get the Value 5, which is the value with the max count.

But I want to get it in the load script.

How can I do this?

Thanks in advance.

Regards,

Sílvia Ganhão

[Clever_Anjos · Accepted solution]

t:

load

Value,

count(Name) as Qty

Resident TestTable

Group by Value;

t2:

load

FirstSortedValue(Value,-Qty) as MaxValue

Resident t;