Load Pivot table

[amit_saini]

Hi Folks,

Can you please suggest how to handle attached Pivot table data in QlikView.

I know cross table function, I can load the whole data in different parts , but is there any simpler way???

Please advice!

Regards,

AS

[Frank_Hartmann · Accepted solution]

this might be helpful:

multi_header_pivot_import.qvw

[sunny_talwar]

Have you tried this?

multi_header_pivot_import.qvw

[avkeep01]

Hi Amit,

I've created an example for you. The only thing is that I hardcoded the "revenue" and "volumes" column, so if you add another type you'll need to update the script.