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
