Loading Issue

[SarvaniTavva30]

  while  Creating the autonumber   Loading issue is coming on Result Table

//Scripting  code for AutoNumber
RegionSales:
Load *,
AutoNumber(Date&Month&Year) as RDYM;
Load * Inline
[
Date,Month,Year,Sales
17,08,1992,800
17,08,1992,700
23,05,1992,900
23,05,1992,900
07,08,2019,1000
23,05,1992,900
];
Store RegionSales into [lib://DataFiles/RegionSales.qvd](qvd);
Result:
Load
Date,
Month,
Year,
Sum(Sales) as Total
Resident RegionSales;
Drop Table RegionSales;

Dataload Error in the below

RegionSales << bc34a63c-e657-4b0b-9e5b-a11807f75e3b Lines fetched: 6 Result << RegionSales Script error: Invalid expression

The following error occurred:

Invalid expression

The error occurred here:

Result: Load Date, Month, Year, Sum(Sales) as Total Resident RegionSales

The following error occurred:

Invalid expression

[mikaelsc]

well... aggregations in script (as in all sql) need to be used in combination with a group by expression... 

Result:
Load
Date,
Month,
Year,
Sum(Sales) as Total
Resident RegionSales

group by Date,Month,Year;
Drop Table RegionSales;