Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Load from QVD: Field not found

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:

[LinkTable]:

LOAD

     // * // only selecting all data with * works good

     [CompanyName] // selecting single fields does not work - Field 'CompanyName' not found

FROM [$(vFolderName)customers.qvd](qvd);

1 Solution

Accepted Solutions
ogster1974
Partner - Master II
Partner - Master II

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.

View solution in original post

3 Replies
ogster1974
Partner - Master II
Partner - Master II

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.

Anonymous
Not applicable
Author

Sure? I thought I saved it through this procedure:

LIB CONNECT TO [Corporate DB (qlik_administrator)];

  [customers]:

  LOAD

[CustomerID] &'_'& [CompanyName] AS KeyCustomer,

      [ContactName],

      [City],

      [Country],

      [DivisionID],

      [Address],

      [Fax],

      [Phone],

      [PostalCode],

      [StateProvince],

  ;

  SQL SELECT * FROM "C:\Data\Corporate DB"."customers";

  STORE customers INTO [$(vFolderName)customers.qvd](qvd);

END Sub

Is this not saving? How would a saving look like?    

ogster1974
Partner - Master II
Partner - Master II

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.