cancel
Showing results for 
Search instead for 
Did you mean: 

Facing error when inner joining two document streams

ddangler
New Contributor III

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

Selection_458

6 REPLIES 6

@the_pan_zone

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

Regards,
Spiro Taleski

dwhansen-cbg
Contributor

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