AYUDA CON CREAR CAMPO

[jose123456]

hola  quisiera ayuda para crear un campo que sume  puntos  por  cliente  algo asii como agg(sum(puntos),clientes)

pero en el scrip o concatenar sum(puntos)  con un string

LOAD DIA,

     Año,

     Fecha,

        day(Fecha)as dia,

     [Player ID],

aggr(sum( [Number of Points]),[Player ID])

     [Apellido y Nombre],

      [Time Played (mm)],

     [Number of Points],

     [Total  In $],

     [Total Out $],

     [Bill In $],

     [Jackpot $],

     Age,

     [City / Town],

     [PLAYER LEVEL],

     Gender,

     [Postal code],

     [Hour Start],

     [Tarjeta CHIPCASH],

     F19,

     F20

FROM

C:\Users\JoseLuis\Desktop\jose.xls

(biff, embedded labels, table is [Player$]);

[Nicole-Smith · Accepted solution]

Data:

LOAD DIA,

     Año,

     Fecha,

     day(Fecha)as dia,

     [Player ID],

     [Apellido y Nombre],

     [Time Played (mm)],

     [Number of Points],

     [Total  In $],

     [Total Out $],

     [Bill In $],

     [Jackpot $],

     Age,

     [City / Town],

     [PLAYER LEVEL],

     Gender,

     [Postal code],

     [Hour Start],

     [Tarjeta CHIPCASH],

     F19,

     F20

FROM

C:\Users\JoseLuis\Desktop\jose.xls

(biff, embedded labels, table is [Player$]);

LEFT JOIN (Data)

LOAD [Player ID],

     sum([Number of Points]) as SumOfPoints

RESIDENT Data

GROUP BY [Player ID];