Where to download the tUnpivotRow compatible with TOS version 7.2?

Five Stars

Where to download the tUnpivotRow compatible with TOS version 7.2?

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

Moderator

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

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

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

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:

 

Captura.PNG

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

 

tempsnip.png

 

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:

 

Captura.PNG

 

Thank you!!

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 3

Read about some useful Context Variable ideas

Blog

Talend Studio Improvements for API Services

Taken a look at the Talend Studio improvements for API Services

Watch Now

Data Integration Success Stories

Take a look at some Data Integration success stories

Read