topic Re: [resolved] how to transform row to column in Talend Studio

[resolved] how to transform row to column

lemufty — Sun, 24 Jul 2016 13:52:35 GMT

hi,
i want to transform column to row. columnName and Columnvalue come from dynamic column(dyn)
column=row1.dyn.getColumnMetadata(columnIndex);
columnName=column.getName();
columnValue=(String)row1.dyn.getColumnValue(columnName);
In output, i have columnName, columnvalue.sample example below:
AccountNumber;1223
AccountSubType__c;bonjour
ActivityIdentificationCode__c;bonsoir
AsstEmail__pc;kpk@gmail.com
AccountNumber;1223qwx
AccountSubType__c;bonjours
ActivityIdentificationCode__c;bonsoirs
AsstEmail__pc;bs@yahoo.fr
so after, i want to have the structure below:
AccountNumber;AccountSubType__c;ActivityIdentificationCode__c;AsstEmail__pc
1223;bonjour;bonsoir;kpk@gmail.com
1223qwx;bonjours;bonsoirs;bs@yahoo.fr
i need your help

Re: [resolved] how to transform row to column

Anonymous — Mon, 25 Jul 2016 07:16:04 GMT

Hi
Please take a look at this article about how to convert columns to rows.
Regards
Shong

Re: [resolved] how to transform row to column

lemufty — Mon, 25 Jul 2016 08:39:19 GMT

hi shong,
i think that i'm not to express correctly. Correct topic is:how to transform row to column
i want to transform row to column.
i tried tunpivot and it don't work. sample example.i have columnName,columnValue
"AccountNumber";"12235adssqq"
"AccountSubType__c";"bonjour"
"ActivityIdentificationCode__c";"bonsoirs"
"AsstEmail__pc";"kpk@gmail.com"
---------------------------------------
"AccountNumber";"12236ads"
"AccountSubType__c";"bonj"
"ActivityIdentificationCode__c";"bonsoir"
"AsstEmail__pc";"test@gmail.com"
i want to have a columnName on only 1 row and other rows are columnValue . sample example:
"AccountNumber";"AccountSubType__c";"ActivityIdentificationCode__c;"AsstEmail__pc"
"12235adssqq";"bonjour";"bonsoirs";"kpk@gmail.com"
"12235ads";"bonj";"bonsoir";"test@gmail.com"

Re: [resolved] how to transform row to column

lemufty — Mon, 25 Jul 2016 12:56:52 GMT

when i use tpivotColumnDelimited and .i have this data file below.

or i want to have the data file below

thank you

Re: [resolved] how to transform row to column

Anonymous — Tue, 26 Jul 2016 10:40:35 GMT

Hi
I think you don't tunpivot component correctly, you need to add a key column after you read the source data, for example:
"AccountNumber";"12235adssqq"
"AccountSubType__c";"bonjour"
"ActivityIdentificationCode__c";"bonsoirs"
"AsstEmail__pc";"kpk@gmail.com"
"AccountNumber";"12236ads"
"AccountSubType__c";"bonj"
"ActivityIdentificationCode__c";"bonsoir"
"AsstEmail__pc";"test@gmail.com"
becomes:
1;"AccountNumber";"12235adssqq"
2;"AccountSubType__c";"bonjour"
3;"ActivityIdentificationCode__c";"bonsoirs"
4;"AsstEmail__pc";"kpk@gmail.com"
1;"AccountNumber";"12236ads"
2;"AccountSubType__c";"bonj"
3;"ActivityIdentificationCode__c";"bonsoir"
4;"AsstEmail__pc";"test@gmail.com"
Below is an example showing how to add a new ID column with the values like 3,2,1,0 for every 4 lines.

Regards
Shong

Re: [resolved] how to transform row to column

lemufty — Wed, 27 Jul 2016 08:19:39 GMT

thank you. it work well