Preceding Load not Working with Group By

[cristian_av]

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];

[stabben23 · Accepted solution]

maybe a typo

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

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

[stabben23]

And Periodo is not a valid Field in Group by