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