Records not passing from one tool to another

TL;DR

Join and filter tool are not passing records to any output points despite matching criteria

I have a workflow that used a number of join and filters.

Quite suddenly one of the join tools which was working on the same data set stop giving any output. Not even Left, Join, or Right output. Everything appears blank. I also noticed that the fieldset I have selected is from Join checklist was also not picked by the other tools down the stream, hence they complained of missing fields

I tried to remove that tool altogether and noticed that all the tools down the line had the same behavior.

This is very perplexing . Any help will be greatly appreciated.

Thank you

Output

Tips and Tricks

Best Practices

Bug

Help

Preparation

Accepted answers

fardeen9983

Unfortunately, we are using workflows deemed confidential as a result I couldn't release even a replica of the same.

Fortunately, though the issue has been resolved. A join tool, later on, was getting an error due to a field name change (fetched from an API) which forced the erroneous Join tool to not process any record as per Alteryx's optimization policy. This was confusing me hence I overlooked the main issue.

Regardless thank you all for the assitance

All comments

atcodedog05

Hi @fardeen9983

This scenario would require investigating the workflow. Without looking at it we cant help you out 😶

OllieClarke

Hey @fardeen9983 I agree with @atcodedog05 that without seeing your workflow it's very hard to help. But as a punt, are any of these tools in containers?

And if so is it possible that their container is disabled, but not collapsed? I think I remember that this was possible in older versions of Alteryx...

fardeen9983

Unfortunately, we are using workflows deemed confidential as a result I couldn't release even a replica of the same.

Regardless thank you all for the assitance

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703