join stuck in 75 and tools after shows 100%

[Hassan_Gammah]

I am using alteryx as ETL and its working fine

but as picture I got this issue : in Join shows 75% but select after shows 100%

if I delete the output tool it will work fine

I have 16 Ram and only used 11

please help I stocked in this issue

[LukeM · Accepted solution]

Hi @Hassan_Gammah 

This must be an issue with your output if it works fine without it. Don't be misguided by the percentage progress indicators as these are only a rough guide to the progress and not gospel on where the workflow is hanging.

Can you troubleshoot by trying to push a dummy table or something else to the same output to see where the issue may be?

Luke

[MichalM]

@Hassan_Gammah 

As @LukeM mentioned, those percentages are not always accurate. I'd also try popping the Block Until Done tool right after the join to make sure all the blending is complete before pushing the data downstream.

[Hassan_Gammah]

output with (create new table ) works fine but (update : insert if new ) doesn't work and it takes me 2 min to insert only 1 row

I think there is issue in alteryx

[User514]

Were you able to fix this issue?