i have a excel file which contains Two Level of header,
i wana know, what will be the best approach to load this type of data..
my excel format is like below:
|Header 1||Header 2||Header 3||Header 4||Header 5||Header 6||Header 7||Header 8||Header 9||Header 10||Header 11||Header 12||Header 13||Header 14||Header 15||Header 16|
|Current Month||Prev Month||YTD|
|Name||Number||Account||ID||Sale||Sale %||Estimated||Actual||Sale||Sale %||Estimated||Actual||Sale||Sale %||Estimated||Actual|
Your Comment would be highly Appreciated.
Hope this will help you, PFA , sample app and XL
you need to load twice for Current Month and Previous Month ,Concatenate the 2 tables and an identifier
field (Current Month and Previous Month)
Steps for Loading
1) In File Wizard type - select Embedded Lables and header size - > Lines -> 2 and click on next
2)In Garbage Tab select conditional Delete and select the Previous column sale, sale % , estimated and actual and click on Delete Marked , Click on Next and Finish
3) Identifier Field 'CurrentMonth' as Monthstatus
5) In File Wizard type - select Embedded Lables and header size - > Lines -> 2 and click on next
6)in Garbage Tab select conditional Delete and select the Current column sale, sale % , estimated and actual and click on Delete Marked , Click on Next and Finish
7) Rename Field like Sale1 to Sale, Sale1% To Sale1, Estimated1 to Esitmated, Actual1 to Actual
7) Identifier Field 'PreviousMonth' as Monthstatus !
Note : If your Data volume is high , this loading technique may affect reloading time , since we are loading twice
Hi Shanmuga Prabhu
Actually I have had read multiples xls from 1 folder. Problem is 4 of the all headers are 1 row upper and their place there are numbers. Those numbers goes chanching according to excel file. I Ittached your excel file but with problem sheet. How could read this situation in qlikview?