Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Please find the attached excel input
When loading the file into QlikView it throws error as Field Not Found
Looking for a solution
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
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$);
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
or simply:
LOAD *
From [https://community.qlik.com/servlet/JiveServlet/download/809479-173031/attendance.xls]
(biff, embedded labels, table is Sheet1$);