Normalize multiple columns

Anonymous — Mon, 20 Aug 2018 13:37:59 GMT

Hi,

Need to normalize multiple columns.

Below is my data

ID| Col1| Col2

1 |a,b,c |d,e,f

2 |g,h,i |j,k,l

Expected result

ID| Col1| Col2

1 |a | d

1 |b | e

1 |c | f

2 |g | j

2 |h | k

2 | i | l

Below is my try,

String[] value1 = input_row.newColumn.split(",");
String[] value2 = input_row.newColumn1.split(",");
int index = input_row.dummy-1;
for(int i= 0; i<value1.length;i++){
for(int j= i; j<=i;j++){
	System.out.println(" Id="+input_row.dummy+"  Col1="+value1[i]+"  Col2="+value2[j]);	

output_row.dummy = input_row.dummy;
output_row.newColumn = value1[i];
output_row.newColumn1 = value2[j];		
	}
}

While printing the statement,

System.out.println(" Id="+input_row.dummy+"  Col1="+value1[i]+"  Col2="+value2[j]);

array is providing four results as expected.

But while passing to the output_row, only the last array is passed. Only one entry is avaliable in the result.

Could any one help out?

Below is the flow,

Inpit - > tjavarow -> output

topic Normalize multiple columns in Talend Studio

Normalize multiple columns