Invalid Expression :(

[pascos88]

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

[tamilarasu]

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.

[sunny_talwar · Accepted solution]

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;