Not applicable
2012-10-24
01:35 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Best Practice for Importing an Excel File
Hello! Good Day,
I would like to ask what is the best practice when importing an Excel File with many headers.
Please do check the example given. I would like to come up with a clean table using the specific sample excel file.
Thank you and Regards,
Dona
929 Views
2 Replies
Not applicable
2012-11-02
07:20 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
best way could be to transpose the table and do a crosstable load afterwards.
both is aviable in the qlikview load dialogue.
i had some crazy excel layouts in the past. but its possible to load most in qlikview.
i will be back with an example after lunch
469 Views
Not applicable
2012-11-02
08:13 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
so, like i say earlier, transpose and crosstable came closer to a solution.
but the date has to be changed in the excel file. each collumn like water and food needs a date.
see example