Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Directory;
LOAD ID,
Nome,
Cognome,
Max(Cell) as MaxC
FROM
MappingLoad.xlsx
(ooxml, embedded labels, table is Foglio1)
Group By Cell;
Someone can see the error in this expression?
Regards
Pasquale
You need to group by fields which are not aggregating. Try this:
LOAD ID,
Nome,
Cognome,
Max(Cell) as MaxC
FROM
MappingLoad.xlsx
(ooxml, embedded labels, table is Foglio1)
Group By ID, Name, Cognome;
Hi Pasquale,
Try,
Directory;
LOAD ID,
Nome,
Cognome,
Max(Cell) as MaxC
FROM
MappingLoad.xlsx
(ooxml, embedded labels, table is Foglio1)
Group By ID, Nome, Cognome;
All non-aggregated fields must be in a group by clause.
You need to group by fields which are not aggregating. Try this:
LOAD ID,
Nome,
Cognome,
Max(Cell) as MaxC
FROM
MappingLoad.xlsx
(ooxml, embedded labels, table is Foglio1)
Group By ID, Name, Cognome;