Qlik Community

QlikView Management

Discussion Board for collaboration on QlikView Management.

Not applicable

How to read the excel data without mentioning column header

Hi All,

How to script without mentioning header line ????? while loading the excel data .

(ooxml, embedded labels, header is 4 lines, table is [Dept]);

Please suggest

1 Solution

Accepted Solutions

Re: How to read the excel data without mentioning column header

Untitled.png

Maybe select None under Labels.

HTH

Best,

Sunny

7 Replies

Re: How to read the excel data without mentioning column header

Untitled.png

Maybe select None under Labels.

HTH

Best,

Sunny

Not applicable

Re: How to read the excel data without mentioning column header

Hey Sunny

unable to get headers name if i select none

neetha_p
Honored Contributor

Re: How to read the excel data without mentioning column header

hi revathi,

Tr.png

Goto File wizard transform and delete rows and columns not required,but with this solution in script n statements for rows and columns will be displayed which is worse than header line mentioned.

other solution is request source provider to give spreadsheets with only one header(Change the format).

Regards

Neetha

neetha_p
Honored Contributor

Re: How to read the excel data without mentioning column header

you can rename column names with header names from excel ,if none is selected

Re: How to read the excel data without mentioning column header

I think once you do what I suggested, you should get something like this:

F1,

F2,

F3

....

You can name them to be whatever you want like this:

F1 as Something1,

F2 as Something2,

....

HTH

Best,

Sunny

Not applicable

Re: How to read the excel data without mentioning column header

i cnt make changes in excel as per client instruction

neetha_p
Honored Contributor

Re: How to read the excel data without mentioning column header

yes you can't change with out clients instructions but request them to provide data with format( one line header)

you can follow sunny's solution and rename fields in UI with header names from excel.

Community Browser