Join Not Working

[Nageen]

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!

[mbarone]

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.).

[Nageen]

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!

[mbarone]

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.

[Nageen]

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!

[mbarone]

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.