Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Announcement | We'll be doing maintenance between 2-3 hours, which may impact your experience. Thanks for your patience as we work on improving the community!
community Alteryx IO Mission Control
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Row replicating many times after a join??

ewall
7 - Meteor
‎07-30-2021 09:48 AM

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??

Labels:
Reply
11 REPLIES 11
ewall
7 - Meteor
‎08-03-2021 07:47 PM

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

Reply
0 Likes
apathetichell
19 - Altair
‎08-03-2021 08:01 PM

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.

Reply
0 Likes
connect with mentors
designer new user guide
Labels