Where to download the tUnpivotRow compatible with TOS version 7.2?

[Anonymous]

Hi,

I've been looking for tUnpivotRow component and all I've found are old versions of it. None of them works with TOS version 7.2. Does anyone know where can I find the most recent version?

Thank you!!

[Anonymous]

Hello,

Do you want to transpose some columns to rows?

Could you please let us know if this solution tjavaflex can achieve your goal?

https://community.talend.com/t5/Design-and-Development/Transpose-Columns-to-Rows/td-p/40077

Best regards

Sabrina

[Anonymous]

Hello,

Yes, I want to transpose some columns to rows but I would like to do it with tUnpivotRow instead of with tJavaFlex because it's easier. Is there any link to download tUnpivotRow compatible with TOS 7.2?

If not, could someone help me to do it with tJavaFlex? Here's my case:

I have this job and I want to transpose the next 9 columns:

Start code:

String splitString = DQ.toString().substring(DQ.toString().indexOf("[")+1,DQ.toString().length()-1);

String[] arr1;
arr1 = splitString.split(",");
String[] arr2;
int[] numArr = {3,4,5,6,7,8,9,10,11}; 
String temp = "";
for(int j = 0;j<numArr.length;j++)
{
if(j!=numArr.length-1)
temp+=arr1[numArr[j]]+",";
else
temp+=arr1[numArr[j]];
}

Main Code

row2.Field = arr2[i];
String temp2 = DQ.toString().substring(DQ.toString().indexOf(arr2[i]+"="),DQ.toString().length()-1)+",";

End Code

}

And here's the schema:

Thank you!!