Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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];
maybe a typo
FirstValue('01-'&Left(mes,2)&'-'&Right(mes,4)) as Ld_Fecha,
LOAD *, Date(Ld_fecha,'YYYYMM') as PeriodoNum; small f
maybe a typo
FirstValue('01-'&Left(mes,2)&'-'&Right(mes,4)) as Ld_Fecha,
LOAD *, Date(Ld_fecha,'YYYYMM') as PeriodoNum; small f
And Periodo is not a valid Field in Group by