Missing match when joining unsorted file

When trying to add columns by doing a left join on identical ID numbers, I noticed that Spotfire miss numerous values when my input file is unsorted, as showed in the pictures attached.

Could someone tell me whether this is a bug or not and, in case it's not, why Spotfire behave like this?

Thank you.


Image icon sorted_file.png87.24 KB
Image icon unsorted_file.png71.06 KB

(1) Answer