Group by in Load

Fri, 25 Jan 2013 13:17:45 GMT

Hi!,

I havbe a problem when i include a sentence group by in a load sentence, give a error but i don't understand why,

udp_hh:

LOAD
@IdUserDaily,
COMPANY,
WORKGROUP,
@Fecha,
HORA_MIN,
USERNAME,
trim(upper(USERNAME)) as RUT,
SUM(TIMEUSERLOGGEDIN) as TIMEUSERLOGGEDIN ,
FULLNAME

FROM $(PathQvd)user_daily_????.qvd (qvd)
WHERE COMPANY='LIPIGAS'
GROUP BY USERNAME
;

please help me, thanks a lot!

Re: Group by in Load

Fri, 25 Jan 2013 14:57:03 GMT

You have to group all the columns that you did not execute any calculation such as Count, Sum etc..

Exemple:

LOAD A, B, SUM(C), COUNT(D)

FROM X

GROUP BY A, B

Best.

topic Re: Group by in Load in QlikView

Group by in Load

Re: Group by in Load