Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
can anyone help me how to load the excel data which contains multiple headers
This should be helpful: https://community.qlik.com/search.jspa?q=multiple+header
- Marcus
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
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
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!