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

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

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

Clever_Anjos — Thu, 11 Jan 2018 10:33:06 GMT

load

Value,

count(Name) as Qty

Resident TestTable

Group by Value;

t2:

load

FirstSortedValue(Value,-Qty) as MaxValue

Resident t;