Alteryx Designer crashes when using Join tool on large datasets

[Rovmenpaul]

Hi everyone,

I’m working with Alteryx Designer 2023.1, and it keeps crashing whenever I try to run a workflow that uses the Join tool on two large datasets (each around 500K+ rows). No error message, just a full crash and the app closes.

I’ve already checked system resources and even tried breaking the data into smaller chunks, but the issue still occurs. Other tools in the same workflow run fine, so it really seems like the Join is the trigger.

I remember reading a discussion led by Eileen Tate a while ago on performance optimization in Alteryx, and I wonder if something similar could be at play here—possibly a memory limit or a known bug in this version?

Would appreciate any insights or suggestions. Thanks!

[gawa · Accepted solution]

@Rovmenpaul 

Check the patch # applied to your using version 2023.1. If that error is the one mentioned as below, it was fixed at Patch-9 so you can apply the latest patch of 2023.1 to fix it.  

https://help.alteryx.com/release-notes/en/release-notes/designer-release-notes/designer-2023-1-relea...