Problem with key on QVD

[hopkinsc]

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

[#2]

Hi, In script to end just write

QUALIFY *.%LKStoreEANDate

[hopkinsc]

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

[#4]

QUALIFY *.%LKStoreEANDate

just link all tables with field %LKStoreEANDate

[hopkinsc]

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??