Transpose using tPivotToColumns component

lmit — Tue, 09 Aug 2022 16:01:47 GMT

Hi All,

I have a file with one row which looks like below

Name --- this is header of my file

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

Re: Transpose using tPivotToColumns component

InfoCraft — Thu, 11 Aug 2022 20:19:45 GMT

Hi @none none,

there are several ways to solve it

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

Kind regards,

😷19.

topic Re: Transpose using tPivotToColumns component in Talend Studio

Transpose using tPivotToColumns component

Re: Transpose using tPivotToColumns component