unable to sort collection

ksaibhargav

New Member
hai i used utility collection manipulation in that sort collection but i am failed to sort the collection field
 

Attachments

  • Capture.JPG
    Capture.JPG
    68.7 KB · Views: 148
  • actual collection.JPG
    actual collection.JPG
    64.2 KB · Views: 147
  • Sorted collection.JPG
    Sorted collection.JPG
    66.8 KB · Views: 136

VJR

Well-Known Member
Can you show the before and after screenshots with the Number datatype for the column.
 

VJR

Well-Known Member
any way i will add in the collection fileds and back with status?
Try checking out if there is any action in the collection vbo to do this. Also add a new number column to the collection and then inside a loop see if by using a Calc stage you can set the new collection field (number) to the old one (text).
 

ksaibhargav

New Member
any way i will add in the collection fileds and back with status?
ya i added profit in the collection fields as number. but it showing error like unable to read the data from excel data item not mached with number type
 

Attachments

  • 1.JPG
    1.JPG
    49.6 KB · Views: 79
  • 2.JPG
    2.JPG
    22.3 KB · Views: 76

VJR

Well-Known Member
ya i added profit in the collection fields as number. but it showing error like unable to read the data from excel data item not mached with number type
See what happens if you set the Profit column in Excel itself as Number in all the cells throughout the column.
Also try the other options I have suggested above.
 
Top