Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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