5 Replies Latest reply: Jun 30, 2015 11:31 AM by Marco Wedel RSS

    Header

      Hi

       

      Please find the attached excel input

       

      When loading the file into QlikView it throws error as Field Not Found

       

       

      Looking for a solution

        • Re: Header
          Antonio Mancini

          Try

           

           

          LOAD @1 as RowNum,
          @2 as [Date],
          @3 as [Bank ID],
          @4 as [Staff Name],
          @5 as [Log Type],
          @6 as [Start Time],
          @7 as [End Time],
          @8 as [Duration (Min)],
          @9 as [CreatedBy],
          @10 as [CreatedDate],
          @11 as [ModifiedBy],
          @12 as [ModifiedDate]
          FROM
          [attendance.xls]
          (
          biff,no labels, header is 1 lines, table is Sheet1$);

           

          Regards,

          Antonio

          • Re: Header
            Gysbert Wassenaar

            Your field names contain square brackets. Qlikview normally uses these to quote field names. Since you want them to be literal strings and not quotes you need to quote the field names, for example with double quotes:

             

            LOAD "[RowNum]",

                 "[Date]",

                 "[Bank ID]",

                 "[Staff Name]",

                 "[Log Type]",

                 "[Start Time]",

                 "[End Time]",

                 "[Duration (Min)]",

                 "[CreatedBy]",

                 "[CreatedDate]",

                 "[ModifiedBy]",

                 "[ModifiedDate]"

            FROM attendance.xls

            (biff, embedded labels, table is Sheet1$);

            • Re: Header
              balaji k

              Hi,

              I Hope it will help u to complete u r task

              LOAD "[RowNum]",

                   "[Date]",

                   "[Bank ID]",

                   "[Staff Name]",

                   "[Log Type]",

                   "[Start Time]",

                   "[End Time]",

                   "[Duration (Min)]",

                   "[CreatedBy]",

                   "[CreatedDate]",

                   "[ModifiedBy]",

                   "[ModifiedDate]"

              FROM

              [C:\Desktop\qlikcommunity examples\worksheets\attendance.xls]

              (biff, embedded labels, table is Sheet1$);

               

               

              Thank you

              Balaji.k

              • Re: Header

                Hi Senthil Kumar,

                 

                Remove that square brackets you are used for column names.

                 

                It will work.

                • Re: Header
                  Marco Wedel

                  or simply:

                   

                  LOAD *

                  From [https://community.qlik.com/servlet/JiveServlet/download/809479-173031/attendance.xls]

                  (biff, embedded labels, table is Sheet1$);