topic Re: Convert columns in to rows in QlikView

Convert columns in to rows

Anonymous — Thu, 11 Aug 2016 07:48:01 GMT

Hi All,

How to convert columns in to rows.

Data format: (Sheet 1 in Excel)

Consutling

ERS

TAX

Audit

IFS

Grand Total

Level

Total

Net Open

Total

Net Open

Total

Net Open

Total

Net Open

Total

Net Open

Total

Net Open

Total

Net Open

Required format:(Sheet 2 in Excel)

Function

Level

Total

Net Open

Total

Thanks,

Krishna

Re: Convert columns in to rows

beck_bakytbek — Thu, 11 Aug 2016 07:54:51 GMT

Hi Krishna,

you can use crosstable ; activate enable Transformation than you will have the File Wizard: Transform, and you have then 5 rows like: Garbage, Fill, Column, Unwrap and Rotate, you can adjust/customize you source Excel.table

i hope that helps

beck

Re: Convert columns in to rows

petter — Thu, 11 Aug 2016 09:04:30 GMT

I guess this might be a solution for you (see attached QVW for full solution):

The load script would like this:

Re: Convert columns in to rows

Anonymous — Thu, 11 Aug 2016 10:44:28 GMT

Hi Petter Skjolden,

Thanks for your support. Please share QVW File.

Regards,

Kalyan.

Re: Convert columns in to rows

trdandamudi — Thu, 11 Aug 2016 11:11:53 GMT

The reason you are not able to see the file because you are looking from Inbox. Just be in community page and you will see it, hope this helps...