Header

[#1]

Hi

Please find the attached excel input

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

Looking for a solution

[antoniotiman]

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

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

[#4]

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

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

Thank you

Balaji.k

[#5]

Hi senthil.psk1,

Remove that square brackets you are used for column names.

It will work.

[MarcoWedel]

or simply:

LOAD *

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

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