...
Important: Both streams must be sorted on the specified key(s). When using the Sort step, this works fine. When you sorted the data outside of PDI, you may run into issues with the internal case sensitive/insensitive flag. Further information can be found on PDI-11440 (illustrating an issue with the Merge join step, but the issue is valid for this step as well).
The following sample illustrates the usage:
...