Alteryx Join count change

[wonka1234]

Hi,

I have a filter before my join filtering for a username and get 341 records at the end of my union.

however when i apply the filter at the end of my union im getting 340 records?

How is this possible?

the correct # should be 340 records.

[MarqueeCrew]

@wonka1234 ,

the join field is NOT unique in the data coming into the right join input anchor.  

put a unique tool before it and set unique to the join field.  You should likely see a difference. 

cheers,

 mark

[wonka1234]

@MarqueeCrew 

Why do you say right anchor? How do you know that?

[MarqueeCrew]

@wonka1234 ,

You seem pretty set on knowing the data counts.   I presume your 340 records are in LEFT anchor.  You hid the right data.  When you join and get more data in the J anchor than expected it is generally because 2 or more join R records exist for the given key field.  

it could be duplicated anywhere, but in my experience it's the right data. 

cheers,

 mark

 was I right?

[wonka1234]

@MarqueeCrew 

Thanks. I have uniqued the join fields in the unique tool, getting smaller amount of records. (41 only)

[wonka1234]

sigh, still wondering why i am not getting 341.

[MarqueeCrew]

Join us case sensitive. Is data mixed?