topic Loading XL tables with two-line headers in QlikView

Loading XL tables with two-line headers

datanibbler — Thu, 02 Jan 2014 08:24:05 GMT

Hi,

a very trivial question - and one which I do have a solution to, I just wonder if there is a more elegant way to do this:

- In many Excel tables that I have to load into one of my QlikView apps, there are headings written across two lines.

=> Is there a "native" way that I can tell QlikView to merge these two lines into one?

<=> Otherwise, I'd just have to remove the first and rewrite the headers.

Thanks a lot!

Best regards,

DataNibbler

Re: Loading XL tables with two-line headers

datanibbler — Thu, 02 Jan 2014 08:32:10 GMT

Hi,

I think this is solved: I tried and removed the 2nd line in the LOAD_wizard and QlikView automatically generated some alias field_names with the complete heading

Best regards,

DataNibbler

Re: Loading XL tables with two-line headers

Thu, 02 Jan 2014 20:41:15 GMT

First we can load the headers and then rename the fields names using map tables.