ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
2 Day Countdown - The Alteryx Community will be temporarily unavailable for a few hours due to scheduled maintenance starting on Thursday, April 22nd at 5pm MDT. Please plan accordingly.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Join not working in Analytic App

lewis-chambers
5 - Atom

Hello,

 

Having a bit of an issue with a workflow which runs fine in Designer but am getting no outputs when trying to convert to an analytic app.

 

Plan is there are two input files which I've called using two the file browse tools from interface. These are then joined based on a common identifier between the two files.

 

When running the tool as an app, I get the error on the join that "Info: Join (6): 0 records were joined with 0 un-joined left records and 0 un-joined right records (ended by a downstream tool)"

 

I've packaged up my example workflow here - really grateful for any advice to help fix this issue!

 

 

jamielaird
14 - Magnetar

Hi @lewis-chambers 

 

To resolve this sort of issue I recommend using the Debug Mode. In the Interface Designer (CTRL+ALT+D or View > Interface Designer) choose the magic wand icon, input your two files, and open Debug Mode. You'll then be able to run this as a workflow and see where the error occurs. To make any corrections, make sure you do this in your main app file not the debug version, which is just a copy.

 

jamielaird_0-1605834775114.png

 

 

You might also want to show some output when the App completes, which you can also do via the Interface Designer, using the Properties tab:

 

jamielaird_0-1605834549282.png

 

lewis-chambers
5 - Atom

D'oh! Thanks very much for your help!!

Labels