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
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