Qlikview load ( transformation) question

[Anonymous]

Hi All,

I have a requirement to load data from an excel report  file. The challenge is excel had multiple title sections that need to be transposed.

My expectation is to load into the following format.

Would someone please help me ?

Please see the sample file attached.

Thanks,

Aji Paul

[vinod305]

Hi Aji Paul,

you can try the concept CrossTable in this by using Qualifier,Attribute,Object.

By using qualifier you can have that output what you are thinking.

[marcus_sommer]

Take a look on this: multi_header_pivot_import.qvw

- Marcus

[Anonymous]

Hi Vinod,

Thanks for the reply, would you please elaborate bit more?

Thanks,

Aji

[Anonymous]

Thanks Marcus

[vinod305]

Hi AjiPaul,

By using Qualifier field u can make multiple columns to single column so that it may reach your requirement i am thinking like this, if it works very happy.

Thank you