Issue about table creation

[#1]

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;

[Gysbert_Wassenaar]

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

[raghvendrasingh · Accepted solution]

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

[#4]

Thanks Gysbert,

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

Regards,

Sandeep

[#5]

Hi Raghvendra,

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

Thanks again,

Sandeep

[raghvendrasingh]

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