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

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:

Join

Accepted answers

alexnajm

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!

All comments

alexnajm

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703