Transpose using tPivotToColumns component

[lmit]

Hi All,

I have a file with one row which looks like below

Name --- this is header of my file

a

b

c

a,b, c are my data , i want my output to be as

a,b,c

I used the component tPivotToColumns component am getting results as expected but my out is looking like below

name,a,b,c

I just want a,b,c

I tried excluding the header in the input file and i tried by adding one default column in tmap as id and value as "1" but still i got result as

id,a,b,c

I tried al the methods suggested in the forum so can anyone suggest the solution am i missing anything in the component settings or can anyone suggest any other method to transpose

Thanks in advance,

Lmit

[Covid19 · Accepted solution]

Hi @none none​,

there are several ways to solve it

--> using tAggregateRow, tDenormalize, tMap, tJavaRow...

Kind regards,

😷19.