Farhan Shariff

Farhan Shariff

  • NA
  • 933
  • 242.2k

Swap Rows based on Comparison

Mar 28 2014 8:59 AM
I have Datatable I want to compare the values and swap the rows
original table1
PName
CN
CR
DS
diff
2.4
2.8
1.5
 prg 1.7
0.5
2.2
new
1.22.1
1.7
 
"CN< 1.6 AND DS >1.5" 
then that has to be moved to top
output
PName
CN
CR
DS
new 1.22.1
1.7
diff2.42.81.5
prg1.7       0.52.2
 

Answers (2)