Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Take a look on this: multi_header_pivot_import.qvw
- Marcus
Hi Vinod,
Thanks for the reply, would you please elaborate bit more?
Thanks,
Aji
Thanks Marcus
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