topic Re: Header in QlikView

Header

Tue, 30 Jun 2015 07:43:50 GMT

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

antoniotiman — Tue, 30 Jun 2015 08:03:21 GMT

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 — Tue, 30 Jun 2015 08:40:32 GMT

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

Tue, 30 Jun 2015 09:08:22 GMT

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

Re: Header

Tue, 30 Jun 2015 09:25:41 GMT

Hi senthil.psk1,

Remove that square brackets you are used for column names.

It will work.

Re: Header

MarcoWedel — Tue, 30 Jun 2015 15:31:37 GMT

or simply:

LOAD *

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

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