Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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