topic Re: Minimum among previous in App Development

Minimum among previous

Anonymous — Wed, 13 Dec 2017 14:18:28 GMT

Hi!

I really need your help

For examle I have a table:

[Letter, Number, date
aaa,5,9

bbb,4,9
aaa,7,10

bbb,3,10
aaa,1,12

bbb,3,12
aaa,6,13]

For each letter I need to get a minimum among previous days

So it would be:

[Letter, Number, date, Min
aaa,5,9, -

bbb,4,9, -
aaa,7,10, 5

bbb,3,10, 4
aaa,1,12, 5

bbb,3,12, 3
aaa,6,13, 1]

How can I do that?

Thanks in advance

shraddha_g — Sat, 16 Dec 2017 06:40:36 GMT

What is the logic behind calculating Min?

sunny_talwar — Sat, 16 Dec 2017 12:54:37 GMT

May be this

Table:

LOAD * INLINE [

Letter, Number, date

aaa, 5, 9

bbb, 4, 9

aaa, 7, 10

bbb, 3, 10

aaa, 1, 12

bbb, 3, 12

aaa, 6, 13

];

FinalTable:

LOAD *,

If(Letter = Previous(Letter), RangeMin(Peek('Min'), PeekedNumber)) as Min;

LOAD *,

If(Letter = Previous(Letter), Peek('Number')) as PeekedNumber

Resident Table

Order By Letter, date;

DROP Table Table;

DROP Field PeekedNumber;

Anonymous — Tue, 19 Dec 2017 10:18:45 GMT

It works!

Thank you!