topic Re: Selecting the header in Qlik Learning Discussions

Selecting the header

Wed, 29 Oct 2014 06:37:24 GMT

Hi.

When i pull an excel report in qlikview, in the second step its giving me 2 options.

1. use column headers

2. add column headers.

i have the headers already in the excel file. so in this scenario i will need to select option 1.

But its not allowing me to select option 1.

May i k now y this happening ?

Thank you.

sushil353 — Wed, 29 Oct 2014 06:43:33 GMT

hi,

Try to use embedded label's while extracting the xl file.

HTH

sushil

Wed, 29 Oct 2014 06:49:51 GMT

hi sushil,

i have no idea on that.

i have an xl file whit raw data, and i ahve defined headers too.

But i couldnt select the option. Can you guide me on the same.

Thank you.

Wed, 29 Oct 2014 09:17:03 GMT

You ought to enter command manually in the script editor. Have you tried this?

Here's an example, specify correctly the lables name, hope this could help you:

Thu, 30 Oct 2014 07:09:33 GMT

When you select an excel report to load in qlikview, you could use the Embedded labels in interface too as shown below :

Thanks,

Madhu

Wed, 05 Nov 2014 10:40:39 GMT

Did you test this ?