topic Re: Issue about table creation in QlikView

Issue about table creation

Fri, 20 Nov 2020 18:02:30 GMT

Hi,

I am relatively new to Qlikview development, and I am having issues with the script below:

I am joining two qvds (Script 1) which seems to be working well, however I want to use the joined information in a subsequent script (script 2) and I though that I would be able to use the name of ProductHeader, however the table name is not recognised.

I believe I am misunderstanding how Qlikview names temporary tables, but any advice would be much appreciated.

Many Thanks,

Sandeep

Script 1:

TmpProducts:

LOAD

InvoiceNumber

,InvoiceSuffix

,InvoiceJobReference

,InvoiceContainer

,SUM(Quantity) AS SUMQuantity

,SUM(Cartons) AS SUMCartons

,SUM(Cube) AS SUMCube

,SUM(FakeCube) AS SUMFakeCube

,SUM(ChargeableWeight) AS SUMChargeableWeight

From

\\test\Products.qvd (qvd)

GROUP BY

InvoiceNumber

,InvoiceSuffix

,InvoiceJobReference

,InvoiceContainer;

LEFT JOIN ([TmpProducts])

LOAD

InvoiceNumber

,InvoiceSuffix

,InvoiceJobReference

,InvoiceContainer

,Quantity

,Cartons

,Cube

,FakeCube

,ChargeableWeight

FROM \\test\InvoiceHeader.qvd (qvd);

ProductHeader:

LOAD

InvoiceNumber

,InvoiceSuffix

,InvoiceJobReference

,InvoiceContainer

,Quantity

,Cartons

,Cube

,FakeCube

,ChargeableWeight

,SUMQuantity

,SUMCartons

,SUMCube

,SUMFakeCube

,SUMChargeableWeight

Resident TmpProducts

Script 2

InvoiceNumber

,InvoiceSuffix

,InvoiceJobReference

,InvoiceContainer

,SUMQuantity as TIHQuantity

,SUMCartons as TIHCartons

,SUMCube as TIHCube

,SUMFakeCube as TIHFakeCube

,SUMChargeableWeight as TIHChargeableWeight

Resident ProductHeader;

Re: Issue about table creation

Gysbert_Wassenaar — Thu, 19 Nov 2015 10:45:44 GMT

The table ProductHeader is not created because the data is appended to TmpProducts. That happens because it has exactly the same fields. If you add Noconcatenate to the load statement for ProductHeader then Qlikview will not concatenate those records to TmpProducts.

ProductHeader:

Noconcatentate LOAD

InvoiceNumber

,InvoiceSuffix

...etc

Re: Issue about table creation

raghvendrasingh — Thu, 19 Nov 2015 10:56:09 GMT

Hi Sandeep,

In Your ProductHeader table, Columns are same as in TmpProducts.

So ProductHeader table is auto concatenated to TmpProducts Table.Then not exists now.

So there are 2 options to resolve this issues either you rename one column name in ProductHeader Table or you need to Write noconcatenate keyword as suggested by Gysbert.

Regards,

Raghvendra

Re: Issue about table creation

Thu, 19 Nov 2015 11:46:43 GMT

Thanks Gysbert,

I made the amendments as suggested and it's worked!

Regards,

Sandeep

Re: Issue about table creation

Thu, 19 Nov 2015 11:47:35 GMT

Hi Raghvendra,

Thank you for the alternative, I think i will try both methods and see which method works best.

Thanks again,

Sandeep

Re: Issue about table creation

raghvendrasingh — Mon, 23 Nov 2015 11:25:57 GMT

Most Welcome Sandeep!!!!!!!!!!!!!!!