Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
ALTER.NEXT:

Join us on Dec 2 for a half-day virtual analytics + data science event!
US & CA customers only

SAVE YOUR SPOT
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!

Multiple Join output null rows

Highlighted
Alteryx Partner

Hi there,

 

I'm trying to use join multiple tool with dimension table that I have and Fact table, the problem is after using join multiple I'm getting rows with null value except one column.

 

I'm gonna explain my case using example:

 

Capture.PNG

 

I joined using these two columns that are match to each other but the problem is I'm getting one more row that all fields are null except that one BelongTo that located in Dimension table. 

 

The real rows' number was: 73,701

after Join: 73,702

 

Why I'm getting extra rows? how can I remove these extra column? how does the join operation process? As I know it should check the equality between these two columns. 

Highlighted
Alteryx
Alteryx

It looks like either this is producing a cartesian join or a multidimensional join.  If you are just joining the Fact and Dimension, then just use the normal Join Tool or Find Replace.

Highlighted
Alteryx Partner

Hi @RishiK , I want to use columns from both tables that's why I need to use multiple join and yes I'm getting multidimensional  error. 

Highlighted
17 - Castor
17 - Castor

Hi @riam_abdullah 

 

Can you share some info about how your multi-join is configured?  Perhaps an image of the configuration?  I'm trying to understand why you are using a multi-join to join 2 tables

 

Dan

 

Highlighted
Alteryx
Alteryx

Dan

 

I agree with you, a normal Join tool should suffice here.

Labels