Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.