DSXchange

Hi,

I have a requirement like this, I have input Columns,

CLNT, PLN, PQ, YTD
C1 P1 5.2 7.4

and I need output as

CLNT, PLN, RT, TR
C1 , P1 , PQ , 5.2
C1 , P1 , YTD, 7.4

I am getting TR column by using Horizontal pivot but Iam not getting RT output column which should contain input column names, is there a way to convert input column names as rows


Thanks,
SomaRaju.

Create an additional set of "columns" upstream, containing the column names, and pivot these columns also.