Row replicating many times after a join??

[ewall]

I'm currently doing a join based on a customer ID. There is 1 row of Customer #1 on the left input, and 1 row of Customer #1 on the right input. I am using customer ID to join. However, somehow on the JOIN output, it creates 8 records for Customer #1, and only 1 of those rows is accurate (the rest are filled with zeroes).

Why/how is this happening? And how do I fix??

[ewall]

@danilang I'll see if I can reproduce it using generic data!

[apathetichell]

I'll reiterate that join multiple does some weird stuff - keep in mind that it always creates the largest number of matching records in a datasource... So if 150 records match on one data source and 1 on another and 1 on another etc --  you'll end up with 150 records and a lot of nulls.