Forum Discussion

darshthakkar's avatar
darshthakkar
Valued Contributor
4 years ago
Solved

Sort snap's functionality

Results of a sort snap (ascending) is a little bit hard to digest. I used a file reader which was reading a single column A (i.e. IDs) and I decided to sort it. The results I get are surprising. In...
pipeline
  • bojanvelevski's avatar
    bojanvelevski
    4 years ago

    Hey @darshthakkar,

    This happens because the field you’re sorting is string, so it is sorted alphabetically.

    As I can see, all of these values support parsing so try and parse them before sorting.

    Ex. : parseInt($ID)

bojanvelevski's avatar
bojanvelevski
Valued Contributor
4 years ago

I apologize, I was confused with a different use case 🙂 Parsing the column so you could have a successful sorting is the right way. There’s no need for further adjustments or trying a different approaches.

  • darshthakkar's avatar
    darshthakkar
    Valued Contributor
    4 years ago

    No worries, thank you for your confirmation.

    • darshthakkar's avatar
      darshthakkar
      Valued Contributor
      4 years ago

      @bojanvelevski: I got your point on formatted, I believe you were referring to the one below:

      That option is available in excel parser snap itself.
      I will keep this in mind and test it standalone, without interfering with my current scenario. Thanks again, your help is much appreciated.