Preceding Load not Working with Group By

cristian_av — Wed, 25 Nov 2020 16:16:04 GMT

I, I'm using a Preceding with Group BY, but I can't make it work!

When I execute the script, I get the error "Field Ld_Fecha not found"

Is there anything wrong with my code?

Thanks!!

Concatenate (VolumenCreado)

LOAD *, Date(Ld_fecha,'YYYYMM') as PeriodoNum;

LOAD

FirstValue(Right(mes,4)) as Periodo,

FirstValue('01-'&Left(mes,2)&'-'&Right(mes,4)) as Ld_Fecha,

'Vol.Ppto' as [OrigenVol],

//FirstValue(espe_codigo),

FirstValue(espe_nombre) as espe_nombre,

//FirstValue(coge_codigo),

'Casa Matriz' as coge_nombre,

FirstValue([Clave Sip]) as ctmv_codigo,

Sum(volumen) as Volumen,

'Generado' as TipoVol

FROM [file.xlsx] (ooxml, embedded labels, table is Hoja1)

GROUP BY Periodo, mes, espe_nombre, [Clave Sip];

Re: Preceding Load not Working with Group By

stabben23 — Wed, 04 Jan 2017 14:29:58 GMT

maybe a typo

FirstValue('01-'&Left(mes,2)&'-'&Right(mes,4)) as Ld_Fecha,

LOAD *, Date(Ld_fecha,'YYYYMM') as PeriodoNum; small f

stabben23 — Wed, 04 Jan 2017 14:37:22 GMT

And Periodo is not a valid Field in Group by