Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
String value = input_row.data;
String[] values = value.split("\\[");
String returnVal = "";
for(int i = 0; i<values.length;i++){
if(values.trim().length()>7){
values = values.substring(7, values.indexOf(" "));
returnVal = returnVal + values + ",";
}
}
output_row.data = returnVal;
@KarthikGs,you can store it variables using tSetvariables, or you can load it to table also.
Hi ,
I have a scenario , which contains comma separated values in 2 cells , I need to normalize both Fields .Like ,
ID | Name | Product | Qty |
1 | John | p1,p2,p3 | q1,q2,q3 |
2 | Shane | p11,p22,p33 | q11,q22,q33 |
I need the output as :
1 | deep | p1 | q1 |
1 | deep | p2 | q2 |
1 | deep | p3 | q3 |
2 | Subha | p11 | q11 |
2 | Subha | p22 | q12 |
2 | Subha | p33 | q13 |
# I tried with tNormalize ( 2times for Product , Qty Fields) but rows are getting repeated with that.
Please give me a solution for that.
Thanks in advance
Regards
Subhadeep