Hi



I am doing a process of converting all the values of key column into a row, for eg



Key col1 col2

1 1 1

1 2 1

1 1 3

1 3 1

2 1 1

2 1 2



What I am doing in the Script is convert this data into



1(key)|1:2:1:3 (All Col1 values),1:1:3:1(all col2 values)

2(key)|1:1,1:2

TO achieve this i am using two while loops and 4 If else loops

Now in my production the number of columns are 4 and the number records in the input file are 0.2 million (2 lac) and this script is taking more than 3 hrs to run.

Any idea on how to minimize the execution time?