Workflow stuck at 76%, no errors, just running and not getting completed.

Hi all,

I have alteryx designer, version: 2018.4.5.55718. My laptop is fairly powerful, with i7 8th gen processor and 16GB RAM.

There are 2 input files. both are excel, one excel is 480MB, other one is around 100MB.

the 100MB file has been used to create a WF and used in a container to input in the other workflow.

the output is just and excel file where I am trying to create a availability report of multiple SKUs taking on hand qty, open POs, min/max into consideration. The logic is correct, and it was working fine in excel until we had alteryx.

Both the workflows are working separately correctly, but now, after using the container it is literally dead but no errors, only warnings. I am new to alteryx and not able to figure it out. Please see the file attached. Let me know, what data you need to replicate it. Thanks a lot.

Stocks availability for Top 50 SKU's Store MDQ-Lanka.yxmd

Join

Accepted answers

jrgo

Hi @saikathalder

You have 3 data cleansing tools in your workflow, but you have no fields selected to cleanse. That said, while this tool is nice to have, I've noticed that it does make a workflow run extremely inefficiently - even if no fields are selected - especially if you're working with large amounts of data (like a 480MB Excel file!).

I'd suggest you remove them and run your workflow to see if the execution improves. If it does then there's your issue. If you still need the operations selected in these tools, you can always use a Multi-Field formula tool and create an expression to perform these cleansing actions.

Hope this helps!

Jimmy
Teknion Data Solutions

All comments

MarqueeCrew

I'm answering from my iPhone. I apologize that I can't see the flow, but can offer you something to check. Is there a join happening where it is stuck? Sometimes the presence of a join that creates a many to many join will East up all of your memory and disk. If the join fields are missing a field this can happen.

cheers,

mark

TonyA

I don't see anything obvious just looking at the workflow. Can you provide a small sample of each of the files? Also, a screen shot of the warnings you're getting could be helpful.

saikathalder

Thanks for the reply. Please see the snapshot. Yes, there are multiple joins in the workflow as well. But the join conditions are very generic and simple. The calculations are also just If else, sum and arithmetic expression. Also, no database connections are present, all the input files are kept in the local machine. So, it should run.

Capture.PNG

saikathalder

The place where it is stuck, is a union and not a join. Yes, there are many joins in the work flow. I am not 100% sure, if those join could be omitted against e simpler formula. I attached snapshot below. Is the join correct?

saikathalder

Hello Mark, no, it is not eating up disk space and RAM, the disk usage is only 14% as per task manager. I am attaching some sample data as well. Here is the sample data attached with the comment.

Master data_Alteryx_availability - sample.xlsx

sample_top sku availability.xlsx

jrgo

Hi @saikathalder

Hope this helps!

Jimmy
Teknion Data Solutions

saikathalder

Hi all,

I reduced 1 of the unions which I felt is not required. so, it ran in 2 minutes, I am not fully sure, what went wrong earlier but seems, the issue of WF getting stuck is solved for now.

I have another issue with the logic of the WF, which I will post in a separate thread. Thanks.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703