topic Re: Script logic in App Development

Script logic

Neha121 — Mon, 03 Nov 2025 23:49:09 GMT

Hi ,

I have below data.. How do I get Max value and MAx value category in same table in script I have tried RagneMax but didnt work..

Year	Comp	Dept	Risk	Value	Max_value	Max Value Category
2020	C1	D1	Low Risk	10	60	Very High
2020	C1	D1	High Risk	20
2020	C1	D1	Very Low Risk	30
2020	C1	D1	Med Risk	10
2020	C1	D1	Very High	60

Re: Script logic

hanna_choi — Tue, 04 Nov 2025 01:18:34 GMT

Hi @Neha121

Do you want to get the MAX value from the data load script?

How about this way?

Re: Script logic

marcus_sommer — Tue, 04 Nov 2025 14:13:20 GMT

In addition to the suggestion from @hanna_choi the aggregation load could be directly joined to the source-table, like here simplified (Key is the place-holder for the needed dimensionality):

t: load * from X;
left join(t)
load Key, max(...) as X, firstsortedvalue(...) as Y resident t group by Key;