topic Re: How to Display Excel sheet Column name in QlikView

How to Display Excel sheet Column name

Anonymous — Mon, 23 Mar 2015 10:39:54 GMT

Hi All,

I'm Loading data from excel sheet to my .qvw file and trying to use the column name but i can't use it.

My Script is :

LOAD A, B, C,D,E,F,G,H,I,J,K,L,M,N,O
FROM

(ooxml, no labels);

My excel sheet column are like Proj_id,EmpID,Location,Defect_ID,Def_Status,Closing_Date

My Question is :

1. I want to display my column name instead of A,B,C when am performing some calculation OR action?

Re: How to Display Excel sheet Column name

Roop — Mon, 23 Mar 2015 10:43:57 GMT

Use the Embedded Labels drop down just below the header size.

Re: How to Display Excel sheet Column name

sagarkharpude — Mon, 23 Mar 2015 10:44:57 GMT

Select embedded Labels while loading the data

Re: How to Display Excel sheet Column name

Mon, 23 Mar 2015 10:45:43 GMT

Hi,

Use Embeded Label in while loading the data see attached file

Thanks

Manju

Re: How to Display Excel sheet Column name

datanibbler — Mon, 23 Mar 2015 10:48:10 GMT

Hi,

just try some different settings in the wizard (when loading the sheet) with the nr. of lines to use as header. If your Excel_sheet does have column_names, you should get those.

Re: How to Display Excel sheet Column name

Anonymous — Mon, 23 Mar 2015 10:57:04 GMT

hi,

sorry i couldn't find the option file wizard in my .qvw file

Re: How to Display Excel sheet Column name

Mon, 23 Mar 2015 11:03:18 GMT

First u click on the table files in edit Script

select the path of the source file once u sleeted automatically File Wizard pop_up will come u can find the Label option over there just u select drop down u will find option called Embedded labels select that

Re: How to Display Excel sheet Column name

sagarkharpude — Mon, 23 Mar 2015 11:05:19 GMT

You will find file wizard option after selecting the excel from your desktop location.

(ooxml, no labels);

and above no labels will get replaced by Embedded labels

(ooxml, embedded labels, table is Sheet1);