topic Problem with key on QVD in QlikView

Problem with key on QVD

hopkinsc — Mon, 12 Sep 2011 09:49:38 GMT

Hi, We have a problem with a unique key that we have created on a QVD (1 QVD per table). We run a script everynight which loads any new data into the relevant QVD's.

Unique keys are created for each QVD to ensure duplicate data is not loaded in. These keys are then used to link some of the tables together.

The problem we have is that i am trying to link 2 tables, the key for one table (ProductSale)is:

and the key for the 2nd table (StoreStockMovement) is:

These keys contain exactly the same fields but the StoreStockMovement table key is missing the '-' in between the field numbers which is causing the link not to work.

My question is, i can change this from now on, but is there anyway i can change the historical data to include the '-' between the field numbers?

Any suggestions would be appreciated

Thanks

Problem with key on QVD

Mon, 12 Sep 2011 11:10:26 GMT

Hi, In script to end just write

QUALIFY *.%LKStoreEANDate

Problem with key on QVD

hopkinsc — Mon, 12 Sep 2011 11:12:13 GMT

Hi, thanks for your reply.. but what will Qulaifying do to it?

Problem with key on QVD

Mon, 12 Sep 2011 11:24:11 GMT

QUALIFY *.%LKStoreEANDate

just link all tables with field %LKStoreEANDate

Problem with key on QVD

hopkinsc — Mon, 12 Sep 2011 11:33:37 GMT

Hi, i'm not sure if i'm understanding you correctly...

The link on one of the tables is wrong as it's missing the hyphen from in between the field numbers... I don't understand how using the QUALIFY funstion will correct this??