Forum Discussion

ddangler's avatar
ddangler
New Contributor III
9 years ago

Facing error when inner joining two document streams

I am trying to do a simple inner join between two document stream but facing the below error : I did select the option as Unsorted but still it fails with reason Not Ascending order
dwhansen-cbg's avatar
dwhansen-cbg
Contributor
6 years ago

I’m having this issue but there is no answer here. I have my sorted streams set to Ascending and am still having the issue. Can someone please help?

Ksivagurunathan's avatar
Ksivagurunathan
Contributor
6 years ago

try to convert number input stream to string before the join snap using a mapper, sort the both the input and then use the join. it should resolve the issue.

  • the_pan_zone's avatar
    the_pan_zone
    New Contributor
    4 years ago

    if the input is alphanumeric then what is the solution
    I am getting below error after using sort snap before join
    Not ascending order: [3V ELECTRICITÉ] and [3RD PARTY ACCOUNT CHECK]

    • SpiroTaleski's avatar
      SpiroTaleski
      Valued Contributor
      4 years ago

      @the_pan_zone

      Try to parse the join fields as strings and sort both inputs before the join operation.

      Regards,
      Spiro Taleski