transpose certain rows to columns

jennytan — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Can somebody help me on this?

I have names, address, contact information and deivery info captured as description in the invoice lines and I have extracted using qlikview which will give me the following format:-

I want to be able to convert the various lines belonging to the same invoice no as a column each so that I can extract the relevant name, address, contact, delivery criteria, etc like this:-

Is it possible to do using Qlikview?

Thanks

Re: transpose certain rows to columns

avinashelite — Fri, 09 Oct 2020 08:40:50 GMT

Try with Generic reload

https://community.qlik.com/t5/Qlik-Design-Blog/The-Generic-Load/ba-p/1473470

topic Re: transpose certain rows to columns in QlikView

transpose certain rows to columns

Re: transpose certain rows to columns