topic qlikview not picking column header in QlikView

qlikview not picking column header

Sun, 26 Jun 2011 09:15:00 GMT

Hello,

I have a text file, where i have some data. The problem is that when i import that data into qlikview, qlikview is not picking the first row as a header row. instead i am getting @1, @2,@3 etc. Do i have to do something special to the text file so that the first row becomes a header row?

Same is the issue with excel file too. instead of the first row as a header row, the qlikview is picking it as a data row, and instead...i am getting A,B,C as column headers

Arif

qlikview not picking column header

kaushiknsolanki — Sun, 26 Jun 2011 09:29:48 GMT

Hi,

When ever you import any file you will get a wizard that shows you the field name and the data from that file.

In the same wizard you will see the option like labels. in this option select Embedded labels.

If you want to skip few first lins from the txt file you can give the no of line you want to skip at "Header Size" option in the wizard.

Regards,

Kaushik Solanki

Re: qlikview not picking column header

Mon, 18 Jun 2012 14:49:04 GMT

Hi Kaushik, hope you can help me out with this too... I'm trying to import an excel spreadsheet with the wizard, but the "Use header columns" appears disabled. I tried saving the file as previous XLS versions but it still doesn't work.

Hope you can give me some tips abou this situation. Sorry for the very basic question but I'm new to the tool.

Thanks in advance.

Re: qlikview not picking column header

Anonymous — Tue, 29 Sep 2015 10:04:39 GMT

Hi,

I have the same problem. Does anybody know how to deal with it?

Thank you!