Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

oen
New Contributor II

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);

Tags (1)
1 Solution

Accepted Solutions
ogster1974
Honored Contributor II

Re: Load from QVD: Field not found

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.

3 Replies
ogster1974
Honored Contributor II

Re: Load from QVD: Field not found

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.

oen
New Contributor II

Re: Load from QVD: Field not found

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
Honored Contributor II

Re: Load from QVD: Field not found

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.