Load from QVD: Field not found

[Anonymous]

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

[ogster1974]

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]

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 · Accepted 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.