Discussion board where members can get started with Qlik Sense.
Hi all, I am getting a Field 'CompanyName' not found when trying to load data saved into a QVD before.
Do you know how to solve?
Code is in the attached TXT document.
Main error is in this code:
// * // only selecting all data with * works good
[CompanyName] // selecting single fields does not work - Field 'CompanyName' not found
Go to Solution.
If you look you've not a save companyname as a field you've created a new field called keycustomer which is customerid and companyname combined.
So you need to reference the alias name.
The reason why it and orderid are not found in your qvds is because you haven't stored the fields in them. in both cases you have stored a concatination of two fields in keycustomer and keyorder so you should refer to these field names.
Sure? I thought I saved it through this procedure:
LIB CONNECT TO [Corporate DB (qlik_administrator)];
[CustomerID] &'_'& [CompanyName] AS KeyCustomer,
SQL SELECT * FROM "C:\Data\Corporate DB"."customers";
STORE customers INTO [$(vFolderName)customers.qvd](qvd);
Is this not saving? How would a saving look like?