Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
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.
Many Thanks
Khan
no one have an idea???
Hi,
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
CurrentMonthLoad:
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
4) Concatenate
Previous MonthLoad:
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
it has many error guys?
If you think that red lines are errors, please ignore them... it will work.. try to read the script and implement the same for your file.
Hi,
If you attach your Excel template then it would be easier to provide solution.
Regards,
jagan.
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?
Thanks!