topic Re: Load script failed due to joining / keeping in QlikView

Load script failed due to joining / keeping

Fri, 29 Jul 2016 09:58:34 GMT

Hello everybody,

I am trying to join some tables and i am getting error while doing that. Please find the log below. Please help in solving. This is quite urgent.

0438 TABLE_Eina_EineFL:

0439 LOAD FK_product AS Material,

0440 sap_purchasing_info_rec,

0441 sap_vendor AS EINA_Vendor,

0442 sap_complete_info_record

0443 FROM [EINA.qvd](qvd)

4 fields found: Material, sap_purchasing_info_rec, EINA_Vendor, sap_complete_info_record, 1 590 896 lines fetched

0445 LEFT JOIN(TABLE_Eina_EineFL)

0446 LOAD sap_purchasing_info_rec,

0447 sap_plant AS EINE_Plant,

0448 sap_planned_deliv_time AS EINE_Planned_Delivery_Tim,

0449 sap_net_price AS EINE_NetPrice

0450 FROM [EINE.qvd](qvd)

0451 WHERE EXISTS(sap_purchasing_info_rec)

4 fields found: sap_purchasing_info_rec, EINE_Plant, EINE_Planned_Delivery_Tim, EINE_NetPrice, 496 216 lines fetched

Joining/Keeping

0453 LEFT JOIN(TABLE_Eina_EineFL)

0454 LOAD sap_plant,

0455 FK_product,

0456 sap_vendor

0457 FROM [EORD.qvd](qvd)

0458 WHERE EXISTS(sap_plant)

3 fields found: sap_plant, FK_product, sap_vendor, 333 263 lines fetched

Joining/Keeping

General Script Error

Execution Failed

Execution finished.

Re: Load script failed due to joining / keeping

antoniotiman — Fri, 29 Jul 2016 11:14:06 GMT

May be

in the last table

WHERE EXISTS(EINE_plant,sap_plant)

Re: Load script failed due to joining / keeping

jonathandienst — Fri, 29 Jul 2016 11:20:28 GMT

There is no association (common fields) between the last table and the tables above, so QV is doing a cross join of 1.5m rows with 0.5m rows (producing 750 billion rows), so your computer is just running out of memory.

You probably should not be aliasing sap_plant and sap_vendor earlier or rename them the same way for the third table.

Re: Load script failed due to joining / keeping

jonathandienst — Fri, 29 Jul 2016 11:22:01 GMT

The statement is for a left join, but QV has to produce the cross join in order to perform the left join.

Re: Load script failed due to joining / keeping

Anil_Babu_Samineni — Fri, 29 Jul 2016 11:23:43 GMT

What you want to achieve here, Can i know which values you want?

Re: Load script failed due to joining / keeping

Fri, 29 Jul 2016 13:57:41 GMT

I want to join EINA with EINE and then the resultant with EORD.