alteryx workflow run very very slow

[lilyyangadsk]

my workflow is basically several layers, first exact match and join then fuzzy match, I was able to generate output file quite fast, but a few days ago, same workflow suddenly can't generate report and it keep running whole night and the next morning is till running, I never changed this workflow, just upload two updated excel file to match.

Can I ask whats the reason of it that slow running? I thought was not enough RAM, so I use new laptop which is 32GB memory, but still keeping running whole night and not generate report.

[danilang]

Hi @lilyyangadsk 

You mention that the workflow uses Excel files, but the workflow you attached actually reads from .yxdb files.  Can you please provide more details about this?  How many records are in your two excel files and the input files that you're doing the matches on?

Can you provide some sample data?

Dan

[lilyyangadsk · Accepted solution]

Here is the two sample file for match. The original file is 46873 records to match with 22544 records. Yesterday I run the whole night and next morning still running.