topic Min() in Script in App Development

Min() in Script

OS92 — Tue, 21 Nov 2023 16:02:31 GMT

Hello,

Why doesnt work? --> Min function

Fault: Invalid Expression

[TEMP3]:
Load
[key.Materialnr] as 'TEMP3.Matnr'
Resident MARC
WHERE [BIGruppe] = '4320'
;

Inner Join [TEMP3]:

[TEMP4]:

Load
[key.Materialnr] as 'TEMP3.Matnr',
Min(If(not IsNull([Liefertermin Planauftrag für TEMP]), [Liefertermin Planauftrag für TEMP])) als 'TEMP .nächsterLGN',
[offene Menge] as 'TEMP.oM'
Resident MSKU
;

Regards,

Oliver

Re: Min() in Skript

David_Friend — Tue, 21 Nov 2023 15:50:10 GMT

@OS92 recommend you post in English for the broadest possible help, thanks!

Re: Min() in Script

brunobertels — Tue, 21 Nov 2023 16:28:54 GMT

You need a group by clause in your table [TEMP_4] :

see example below

Temp:

LOAD * inline [

Customer|Product|OrderNumber|UnitSales|CustomerID

Astrida|AA|1|10|1

Astrida|AA|7|18|1

Astrida|BB|4|9|1

Astrida|CC|6|2|1

Betacab|AA|5|4|2

Betacab|BB|2|5|2

Betacab|DD

Canutility|DD|3|8

Canutility|CC

] (delimiter is '|');

Min:

LOAD Customer, Min(UnitSales) as MyMin

Resident Temp

Group By Customer;

So it could be

[TEMP4]: