I am using the below script to construct a link table between Sales and Returns and I am getting a field not found error.
Returns:LOAD ProductKey & '|' & TerritoryKey as key,//ProductKey,ReturnDate,//TerritoryKey,ProductKey,ReturnQuantityFROM[C:\Users\lenovo\Desktop\QVDs\AdventureWorks_Returns.qvd](qvd);
TotalSales:Load ProductKey & '|' & TerritoryKey as key,OrderDate,//StockDate,OrderNumber,//ProductKey,CustomerKey,//TerritoryKey,OrderLineItem,OrderQuantityResident Sales2015;Drop Table Sales2015;
LinkTable:LOAD DistinctProductKey & '|' & TerritoryKey as key,ProductKey,TerritoryKeyresidentTotalSales;
ConcatenateLOAD DistinctProductKey & '|' & TerritoryKey as key,ProductKey,TerritoryKeyresidentReturns;
The error I am getting is Field 'ProductKey' not found and Field 'TerritoryKey' not found.
What am I doing wrong here?
You're trying to load fields into the link table (in both loads) that have been commented out of the underlying resident table, so they don't exist in that table... that won't work.
If you need them, you'll have to load them in the original table. You can rename them and then drop field on the original if that's the data structure you're after.
Enable generate log file in your app setting and see what table it gives you field not found.And then check the original table if you have that field?