Load Script Error - One Field 2 times

[Anonymous]

Hi,

why is here an error and how can i fix it?

regards,

Sam

[sunny_talwar]

TOTAL Qualifier is not available in the script... to do this, you can try this

Table:

LOAD sDate,

     Product,

     Number,

     Store

FROM .....;

Left Join (Table)

LOAD Max(sDate) as Max

Resident Table;

FinalTable:

LOAD *,

      If(sDate = Max, Number) as New_Number

Resident Table;

DROP Table Table;

[jmvilaplanap]

Whats the error description in the console?