3 Replies Latest reply: Jan 9, 2018 6:56 PM by Andy Weir RSS

    Load from QVD: Field not found

    Omar Pennacchio

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

        • Re: Load from QVD: Field not found
          Andy Weir

          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.

            • Re: Load from QVD: Field not found
              Omar Pennacchio

              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?