Aggregation expressions required by group by Clause in Applymap function

[Vinni2000]

Order:

Load 

Locationnumber, 

Ordernumber,

Locationnumber &'-'&Ordernumber as po_number,

Itemnumber,

Voidind 

From qvd;

VoidMap:

Mapping Load 

po_number,

If(IsNull(Voidind),'not voided','voided') as voidstatus,

Resident Oder

Group by po_number;

Order1:

LOAD 

*,

ApplyMap('VoidMap',po_number,'Not voided') as orderstatus

Resident Order;

Drop table Order

[rubenmarin · Accepted solution]

Hi, if there is a group by you need an aggreation expression for the fields not included in the group by clause, like:

Mapping Load 

po_number,

If(IsNull(Max(Voidind)),'not voided','voided') as voidstatus,

Resident Oder

Group by po_number;

You can also use maxstring if Voidind is a text.