Error in expression: ')' expected

[#1]

Im trying to load the following script:

MAP_NFONDOS:

Mapping

LOAD

     Codigo_Ppal_Corto_Key,

     Count([DISTINCT]Producto_Cod_AñoMes_Key) as N_Fondos_Cliente

Resident F_OPERACIONES_SALDO

Where Tipo_Dato = 'Saldo'

Group by Codigo_Ppal_Corto_Key;

I don´t know where is the mistake, could you please help me?

Regards

[sunny_talwar · Accepted solution]

May be try this:

MAP_NFONDOS:

Mapping

LOAD Codigo_Ppal_Corto_Key,

     Count(DISTINCT [Producto_Cod_AñoMes_Key]) as N_Fondos_Cliente

Resident F_OPERACIONES_SALDO

Where Tipo_Dato = 'Saldo'

Group by Codigo_Ppal_Corto_Key;