topic Re: Where to download the tUnpivotRow compatible with TOS version 7.2? in Talend Studio

Where to download the tUnpivotRow compatible with TOS version 7.2?

Anonymous — Sat, 16 Nov 2024 05:13:41 GMT

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!!

Re: Where to download the tUnpivotRow compatible with TOS version 7.2?

Anonymous — Mon, 22 Jul 2019 05:12:23 GMT

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

Re: Where to download the tUnpivotRow compatible with TOS version 7.2?

Anonymous — Mon, 22 Jul 2019 12:16:51 GMT

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!!