Unexpected results with Join

Question

I've been attempting a join between two Excel files with the exact same number of records however, one file has a few additional fields that I need to combine with file number one. Joining on common field of "invoice number".

When I've done this in the past, resulting output file has contained the same number of records but with the additional fields. Now I am getting an output with over 9 million records rather than the 300k expected.

The last time I ran the workflow, I received this error:  "Error: Designer x64: The Designer x64 reported: You have found a bug. The pipe has been ended."

I have not seen this before.

Luke_C · Answer

Got it, that makes sense. I wouldn't worry too much about that bug message if it was a one time event and not constantly reproducible.

Mikegoldnj · Answer

I think I just resolved this  by moving the placement within the workflow of the Unique tool. Seems I am now ending up with the output file having the correct number of records.

Still a bit puzzled by the "bug" error message.

Luke_C · Answer

Hi @Mikegoldnj

If possible it would be helpful for you to share some sample data, the part of the workflow having issues, or maybe some screenshots of your tool configurations.