[Help] Join + Union (J+L) tool isn't returning all the values

[tavares123456]

Hi, I'm trying to solve the following problem:

I have my full base (I'm connecting in the right) and a from-to in the left, in this from-to I have two informations: the SKU code and an extra information about the SKU that I need to add to my base. 

In the join I join the columns SKU code from each base and then I remove the right column SKU code and I keep the extra information that I need. - Important information is that I don't have all the SKU codes in this second file. 

But when I check the results from the join it doesn't return all the values (I'm doing a sum of all costs before and after the join to check it), then I saw that I could do a J + L union to have all the values, but still yet it doesn't match the costs before all this and after the union

Does anyone knows what can I do?

Here is the flow:

[alexnajm · Accepted solution]

Can you show the connection progress so we can see the record counts? Just like the screenshot here: Solved: Connection Progress - Not Showing though dropdown ... - Alteryx Community

Also where are you doing a sum of all costs before the join? I'd expect to see a Summarize tool at that Formula!

[LindonB]

I'd recommend on clicking each output of the join (L, J, and R) and inspecting what falls out. It's possible you have a partial list.

[tavares123456]

I was able to solved, thank you guys! 

In the end I was indeed comparing with the wrong value Alex, my mistake!

Thanks for the help