Multi join issue

[jboschee]

Hi everyone,

I'm using a multi-join to bring in exchange rates and country prices.  My exchange rate has extra countries included that won't match some of the countries.  When I look at the output, where the country and the exchange rate don't match the is an extra line that includes just the exchange rate.  Below is a rough example of what I'm seeing.  I thought that if there was no match that it would be excluded, but looks like I'm wrong.

France  5.00 euro  exchange rate 1.3

                                                       2.0

Germany 4.00 euro exchange rate 1.3

Thanks in advance!

[LordNeilLord · Accepted solution]

Hey @jboschee

Try ticking this option:

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

[jboschee]

Thanks @LordNeilLord!!!