topic Best Practice for Importing an Excel File in QlikView

Best Practice for Importing an Excel File

Wed, 24 Oct 2012 05:35:15 GMT

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

Fri, 02 Nov 2012 11:20:11 GMT

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

Fri, 02 Nov 2012 12:13:01 GMT

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