Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
datanibbler
Esteemed Contributor

Loading XL tables with two-line headers

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

Tags (1)
2 Replies
datanibbler
Esteemed Contributor

Re: Loading XL tables with two-line headers

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

Not applicable

Re: Loading XL tables with two-line headers

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

Community Browser