Facing error when inner joining two document streams

[ddangler]

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

[SpiroTaleski]

@the_pan_zone

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

Regards,
Spiro Taleski

[dwhansen-cbg]

Changing the ORDER BY to Unsorted or adding Sort Snap before the Join fixed the issue.