topic Can't correctly call excel column in QlikView

Can't correctly call excel column

Wed, 06 Aug 2014 15:55:09 GMT

I am tasked with uploading data to a dashboard I have been working on. The new month data just came in and an error popped up. The leaders had added a (mm/dd/yy) to the column title, which wouldn't be a problem, except it is on a whole new line, like they hit the enter key. Does anyone know how to pull a field from an excel sheet that has an enter key like function inside it?

Re: Can't correctly call excel column

MarcoWedel — Wed, 06 Aug 2014 16:07:32 GMT

let the import wizard create the load statement and rename the field using "as".

hope this helps

regards

Marco

Re: Re: Can't correctly call excel column

MarcoWedel — Wed, 06 Aug 2014 17:09:13 GMT

like this:

table1:
LOAD
[column name
with line break],
[column name
with line break] as NewName
FROM QlikCommunity_Thread_128499.xlsx
(ooxml, embedded labels, table is Tabelle1);

table2:
LOAD
  A as NewName2
FROM QlikCommunity_Thread_128499.xlsx
(ooxml, no labels, header is 1 lines, table is Tabelle1);

regards

Marco

Re: Can't correctly call excel column

MarcoWedel — Wed, 06 Aug 2014 19:14:57 GMT

Table 2 is created renaming all the fields during load (Without embedded labels).

regards

Marco