Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

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

2 Replies
Not applicable

Re: Best Practice for Importing an Excel File

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

Not applicable

Re: Best Practice for Importing an Excel File

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

Community Browser