Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
sunny_talwar

Untitled.png

Maybe select None under Labels.

HTH

Best,

Sunny

View solution in original post

7 Replies
sunny_talwar

Untitled.png

Maybe select None under Labels.

HTH

Best,

Sunny

Not applicable
Author

Hey Sunny

unable to get headers name if i select none

Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

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

sunny_talwar

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
Author

i cnt make changes in excel as per client instruction

Anonymous
Not applicable
Author

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.