MergeMultiple rows into columns

[venkatg6759]

Hello Everyone,

                          I have below table

Desc	Val
Errors	1
Category	Loan
Sub Category	Loan Sold
Label	Record Count

I Need to separate and make it show like this

Errors   Category   Sub Category      Label

1           Loan          Loan Sold            Record Count

Can anyone help me how to do this.

Thanks in advance,

Venkata

[MarcoWedel]

Hi,

another version of a script to recombine tables generated by a generic load into one can be found here:

Use cases for Generic Load | Qlikview Cookbook

by Rob Wunderlich

hope this helps

regards

Marco