topic Re: LOAD syntax error in QlikView

LOAD syntax error

sculptorlv — Wed, 25 Nov 2020 16:16:04 GMT

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:"

Re: LOAD syntax error

Anil_Babu_Samineni — Thu, 03 Aug 2017 05:51:07 GMT

Because, you are dropping the table where Resident with Aggregation. Can you try this?

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 ;

NoConcatenate

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;

Re: LOAD syntax error

arvind_patil — Thu, 03 Aug 2017 05:51:38 GMT

Hi Ruslans,

Use No concate inbetween and reload:

DATA_DELIVERY_STATISTICS:

SQL SELECT ...

FROM .....

;

NoConcatenate

DATA_DELIVERY_STATISTICS_MONTHLY:

LOAD

Driver_ID,

Order_Number,

Item_Quantity,

Location_Code,

MonthName(Delivery_Date) AS Delivery_Date

RESIDENT DATA_DELIVERY_STATISTICS

;

NoConcatenate

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 check this code. It will work.

Thanks,

Arvind Patil

Re: LOAD syntax error

sculptorlv — Thu, 03 Aug 2017 05:59:30 GMT

Guys, I don't get it..

I have error on NoConcatenate function. All other code is the same. What should I do, can you please concertize?

Thank you in advance

Re: LOAD syntax error

sculptorlv — Thu, 03 Aug 2017 06:01:20 GMT

I commented last row:

//DROP TABLE DATA_DELIVERY_STATISTICS_MONTHLY;

and got the same error, I guess it is not about drop function for aggregated table.

Re: LOAD syntax error

antoniotiman — Thu, 03 Aug 2017 06:04:18 GMT

Hi Ruslans,

if DATA_DELIVERY_STATISTICS and DATA_DELIVERY_STATISTICS_MONTHLY have the same fields

then QV Concatenate these.

If You Use NoConactenate You get Synthetics Key.

You can

MonthName(Delivery_Date) AS Delivery_Date_Month

Resident DATA_DELIVERY_STATISTICS instead DATA_DELIVERY_STATISTICS_MONTHLY

Ctrl+T make You see Tables You are loading.

Regards,

Antonio

Re: LOAD syntax error

techvarun — Thu, 03 Aug 2017 06:07:52 GMT

Please share sample data

Re: LOAD syntax error

Anil_Babu_Samineni — Thu, 03 Aug 2017 06:09:21 GMT

If i want to work on this, I would prefer to use this

DATA_DELIVERY_STATISTICS:

Load *;

SQL SELECT ...

FROM ..... ;

Left Join (DATA_DELIVERY_STATISTICS)

LOAD

Driver_ID,

Order_Number,

Sum(Item_Quantity) as Item_Quantity,

Location_Code,

MonthName(Delivery_Date) AS Delivery_Date

RESIDENT DATA_DELIVERY_STATISTICS Group By <All Non Aggregate dimensions> ;

Re: LOAD syntax error

sculptorlv — Thu, 03 Aug 2017 06:12:46 GMT

I found out, that this code works!! But still this funcion is highlighted:

Re: LOAD syntax error

sculptorlv — Thu, 03 Aug 2017 06:13:34 GMT

Thanks!

I will do this ..

Re: LOAD syntax error

Anil_Babu_Samineni — Thu, 03 Aug 2017 06:15:28 GMT

May be use NoConcatenate after Directory Name like

Data_Delivery....

NoConcatenate

Load .....

Re: LOAD syntax error

sculptorlv — Thu, 03 Aug 2017 06:18:05 GMT

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

Re: LOAD syntax error

sasiparupudi1 — Thu, 03 Aug 2017 06:20:38 GMT

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;

Re: LOAD syntax error

arvind_patil — Thu, 03 Aug 2017 06:24:16 GMT

Hi Ruslans,

I am wandering to know whats wrong in my code.

Thanks,

Arvind Patil