LOAD syntax error

[sculptorlv]

Hello please help me with the syntax, what I am doing wrong?

DATA_DELIVERY_STATISTICS:

     SQL SELECT ...

     FROM .....

     ;

DATA_DELIVERY_STATISTICS_MONTHLY:

     LOAD

          Driver_ID,

          Order_Number,

          Item_Quantity,

          Location_Code,

          MonthName(Delivery_Date) AS Delivery_Date

     RESIDENT DATA_DELIVERY_STATISTICS

     ;

DATA_DELIVERY_QUANTITY:

     LOAD

          Driver_ID,

          Delivery_Date,

          SUM(Item_Quantity) AS Item_Quantity_Sum_Monthly

     RESIDENT DATA_DELIVERY_STATISTICS_MONTHLY

     GROUP BY

          Driver_ID,

          Delivery_Date

     ;

DROP TABLE DATA_DELIVERY_STATISTICS;

DROP TABLE DATA_DELIVERY_STATISTICS_MONTHLY;

And I got mistake about last load:

"Table not found

DATA_DELIVERY_QUANTITY:"

[Anil_Babu_Samineni]

May be use NoConcatenate after Directory Name like

Data_Delivery....

NoConcatenate

Load .....

[sculptorlv]

Yes! Now it looks and works perfect! Thank you very much!

[sasiparupudi1]

Hi Ruslans,

The script works fine, please provide a sample.

DATA_DELIVERY_STATISTICS:
Load * Inline
[
Driver_ID,Order_Number,Item_Quantity,Location_Code,Delivery_Date
];

DATA_DELIVERY_STATISTICS_MONTHLY:
NoConcatenate   LOAD
          Driver_ID,
          Order_Number,
          Item_Quantity,
          Location_Code,

          MonthName(Delivery_Date) AS Delivery_Date

     RESIDENT DATA_DELIVERY_STATISTICS
     ;

DATA_DELIVERY_QUANTITY:
NoConcatenate  LOAD
          Driver_ID,
          Delivery_Date,
          SUM(Item_Quantity) AS Item_Quantity_Sum_Monthly

     RESIDENT DATA_DELIVERY_STATISTICS_MONTHLY
     GROUP BY
          Driver_ID,
          Delivery_Date
     ;

DROP TABLE DATA_DELIVERY_STATISTICS;
DROP TABLE DATA_DELIVERY_STATISTICS_MONTHLY;

[arvind_patil]

Hi Ruslans,

I am wandering to know whats wrong in my code.

Thanks,

Arvind Patil