multi header in excel

[nareshthavidishetty]

Hi all

can anyone help me how to load the excel data which contains multiple headers

[marcus_sommer]

This should be helpful: https://community.qlik.com/search.jspa?q=multiple+header

- Marcus

[jagan]

Hi,

Check this link

multi_header_pivot_import.qvw

Hope it helps you.

Regards,

Jagan.

[nareshthavidishetty]

thanks for the reply but the data is in the other format like the first 2 rows contain the headers tht i can remove by jus selecting the lines where as the problem is in one of the colomn there are agn 3 r 4 headers present where i stuck now

                                   oct15

                                sales-value

                                     cn

saleable     non-salable       gross sales  total   net value

this is how the data is present in one of the coln

[nareshthavidishetty]

the data is in different format kindly have a look plz

thanks for the reply but the data is in the other format like the first 2 rows contain the headers tht i can remove by jus selecting the lines where as the problem is in one of the colomn there are agn 3 r 4 headers  in the column present where i stuck now

                                   oct15

                                sales-value

                                     cn

saleable     non-salable       gross sales  total   net value

this is how the data is present in one of the coln

multi header in excel

[effinty2112]

Hi Naresh,

This is a really awful spreadsheet to import from. I'm not saying that it's not possible but its not straightforward because this sheet is far removed from nice unformatted raw data. The QV file wizard is very good at helping you write a script that can manipulate a spreadsheet's content, even making sense of some highly formatted files, but what you have here is an example where the creator of this spreadsheet has taken his/her source data and went to great lengths to present it like a report. If you can't get hold of the source data then I think your best bet would be to work on the spreadsheet a little first before throwing it at QV.

I would suggest unmerging cells, taking out calculated columns and reducing the number of header rows which will mean adding to the text of the header rows you are left with.

Good luck!