topic Re: Qlikview load ( transformation) question in QlikView

Qlikview load ( transformation) question

Anonymous — Wed, 20 Jun 2018 04:01:47 GMT

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

Re: Qlikview load ( transformation) question

vinod305 — Wed, 20 Jun 2018 04:33:21 GMT

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.

Re: Qlikview load ( transformation) question

marcus_sommer — Wed, 20 Jun 2018 07:50:38 GMT

Take a look on this: multi_header_pivot_import.qvw

- Marcus

Re: Qlikview load ( transformation) question

Anonymous — Thu, 21 Jun 2018 01:57:47 GMT

Hi Vinod,

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

Thanks,

Aji

Re: Qlikview load ( transformation) question

Anonymous — Thu, 21 Jun 2018 01:58:04 GMT

Thanks Marcus

Re: Qlikview load ( transformation) question

vinod305 — Thu, 21 Jun 2018 07:07:05 GMT

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