Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I would use group by like in sql but my code doesn't run.
I understand I must use group by with a resident table but impossible to run my app!!
load ID_DI, count ([ID_Intervenant]) as [nb techniciens] resident tab group by ID_OT;
Could help me please?
However last day i tested that it is not necessary to use all fields.
This you can do in two step.
1. load orignal table.
2. take resident of orignal table and use the field and expression, something like this below
load
ID_OT,
Count( ID_Intervenant ) as nb_technicien
Resident OT Group by ID_OT ;
Actually Mr XAVIER is using the below code
load ID_DI, count ([ID_Intervenant]) as [nb techniciens] resident tab group by ID_OT;
but if instead he use
load
ID_OT,
Count( ID_Intervenant ) as nb_technicien
Resident OT Group by ID_OT ;
it will definetly work.
ANANT
Yes you are right .
Narender
Hi,
I have another question related to group by -
example-
Load-
QOH,
ITEMCOST,
QOH*ITEMCOST AS TOTAL COST,
LISTPRICE,
SUM(QOH*LISTPRICE)
What fields do I group by this on? In group by if I am calling Total Cost it says not found. Do I use formula in the groupby then?