Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi, In script to end just write
QUALIFY *.%LKStoreEANDate
Hi, thanks for your reply.. but what will Qulaifying do to it?
QUALIFY *.%LKStoreEANDate
just link all tables with field %LKStoreEANDate
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??