community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Join Not Working

Asteroid

Hello, 

 

The workflow I am updating has two joins in a row. The first join is sending data through the right and left outputs. However, the second join is unable to join the data and produces 0 outputs. I have checked all data types and they are the same throughout the workflow. 

 

Any ideas on why this might be happening and how to fix this? 

 

Thanks in advance!

Pulsar
Pulsar

Hmm.....will need a little more information.  Do you have a screen shot of this?  Or perhaps some sample data that can be shared to illustrate the behavior?  Based just on what you entered so far, I can only guess that you are joining on string fields and maybe you need to do some standardizing (trim, get in same case, replace empties, etc.).

Asteroid

They are Vstring fields of the same size (255). The data was standardized right after the select tool earlier in the workflow. I can't provide any data or screenshots but I hope this helps a little. 

 

Thank you!

Pulsar
Pulsar

Would need at least basic information such as:

 

1.  For your first join, what is the key(s) you are joining on?

2.  For your first join, what output nodes are you connecting to the second join?

3.  On the second join, what is the key(s) you are joining on?

4.  On the second join, what output nodes are you expecting to get data out of.

 

Without at least that basic info, it will be difficult to help.



Highlighted
Asteroid

Thank you for this information. My answers are below: 

 

1.  For your first join, what is the key(s) you are joining on?

-We are joining on a formulated field ([new field]) which was creating using the formula node and combining [column] 1 + [column 2]

2.  For your first join, what output nodes are you connecting to the second join?

-Left and right output nodes

3.  On the second join, what is the key(s) you are joining on?

-just [column 1]

4.  On the second join, what output nodes are you expecting to get data out of.

-join output node

 

Thank you!

 

Pulsar
Pulsar

You're joining a file to itself?  Or separate files?

 

You'll have to put together some sample data.

 

You can use text tools to create some fake data, make a fake workflow, and then post it here.

Labels