topic Re: xlsx file load issue in QlikView

xlsx file load issue

Mon, 13 May 2013 09:30:44 GMT

I am having a problem with loading an xlsx document into Qlikview. I am loading xls files with the same format so need them to load together but when I put in the script below and change it to load xlsx files (i.e. put in the file type as ooxml etc.) it doesn't recognise the field names with the numbers in them as column names e.g. [1]. If I remove the brackets it loads but then it loads the numbers as the data which is obviously not what I want. I can't use the LOAD * statement as I need some of the column names to change:

CrossTable (Day, [Number of Welds], 7)
LOAD
right(filebasename(),7) as Period,
'Inside Boiler 89mm Below' as [Weld Category],
[Welders Name] as [Welders Name],
Title as Title,
Station as Station,
[Stamp No.] as [Stamp No],
[Day Count] as [Weld Type],
[1],
[2],
[3],
[4],
[5],
[6],
[7],
[8],
[9],
[10],
[11],
[12],
[13],
[14],
[15],
[16],
[17],
[18],
[19],
[20],
[21],
[22],
[23],
[24],
[25],
[26],
[27],
[28],
[29],
[30],
[31]

FROM
$(ActualDirectory)Welder Analysis - Babcock*.xls
(biff, embedded labels, header is 5 lines, table is [Inside Boiler 89mm Below$], filters(
Replace(2, top, StrCnd(null)),
Replace(3, top, StrCnd(null)),
Replace(4, top, StrCnd(null)),
Remove(Row, RowCnd(CellValue, 4, StrCnd(contain, 'Total'))),
Remove(Row, RowCnd(CellValue, 6, StrCnd(contain, 'WRR')))
));

Is this a bug in Qlikview and if so how can I get around it?

Re: xlsx file load issue

Thu, 06 Jun 2013 16:26:39 GMT

Hi,

I was wondering if you found a solution for this problem. We are having a similar issue now where we changed the syntax from biff, embedded labels, table is [QLIKVIEW$]); to (ooxml, embedded labels, table is DATA); to load xlsx files now instead of xls files, but when we upload the data it does not recognize the field names or the column that we ask it to.

Thanks

Re: xlsx file load issue

Fri, 07 Jun 2013 06:37:42 GMT

Apparently it was a bug in Qlikview but they have fixed it so if you download the latest version of Qlikview 11 from the website those issues should be sorted out now. Haven't tested it yet but hopefully it has been all sorted out

Kind regards

Colleen