Alteryx Designer Desktop Discussions

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

Missing records from Join Tool, just field headers

jakemiroquai
7 - Meteor

Hi there, I am currently using the join tool to match common fields to essentially combine the data. However, despite matching specific fields and ensuring they have are of the same type (V_string, double etc), the output from the join tool shows no records. Does anyone know what could be causing this issue? Please refer to the photos I have attached. Thank you!

2 REPLIES 2
apathetichell
18 - Pollux

you see no records because nothing matched. we can't tell you why without seeing the data. generally I'd look for case issues between columns. If you post sample data that would help.

caltang
17 - Castor
17 - Castor

Please provide relevant data to this use case, and kindly provide your criteria in as much detail as possible. If you have a workflow built halfway, kindly export that over as well.

 

To export a workflow go to: Options > Export Workflow. Kindly do NOT send a "Save As" copy.

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Labels