topic Re: Field not found error in link table in QlikView

Field not found error in link table

ritvik4BI — Thu, 18 Mar 2021 18:05:46 GMT

Hi All,

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,
ReturnQuantity
FROM
[C:\Users\lenovo\Desktop\QVDs\AdventureWorks_Returns.qvd]
(qvd);

TotalSales:
Load ProductKey & '|' & TerritoryKey as key,
OrderDate,
//StockDate,
OrderNumber,
//ProductKey,
CustomerKey,
//TerritoryKey,
OrderLineItem,
OrderQuantity
Resident Sales2015;
Drop Table Sales2015;

LinkTable:
LOAD Distinct
ProductKey & '|' & TerritoryKey as key,
ProductKey,
TerritoryKey
resident
TotalSales;

Concatenate
LOAD Distinct
ProductKey & '|' & TerritoryKey as key,
ProductKey,
TerritoryKey
resident
Returns;

Exit script;

The error I am getting is Field 'ProductKey' not found and Field 'TerritoryKey' not found.

What am I doing wrong here?

Regards.

Re: Field not found error in link table

Or — Thu, 18 Mar 2021 18:36:52 GMT

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.

Re: Field not found error in link table

MK9885 — Thu, 18 Mar 2021 19:19:53 GMT

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?