Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

xlsx file load issue

Hi

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?

2 Replies
Not applicable
Author

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

Not applicable
Author

Hi

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