Huge excel files to pull from sharedrive

Question

We have few excel files that are kept in sharedrive. These files are huge in size (somewhat around 250 MB each) . I have to prepare an Alteryx workflow (and publish this workflow to Alteryx Server) which pulls these files directly from sharedrive and do the manipulations accordingly. As the excel files are large in size Alteryx will take a lot of time to pull these files from sharedrive to Alteryx server. is there a way that I can make this process faster.

1) The excel files will increase in size next year.

2) These excel files are not static and gets updated everyday.

--

Regards

Rahul

Rahul3 · Answer

Hi mathieuf,

Right now when I'm running the workflow on my local machine and my input files are on sharedrive, then Alteryx takes around 10-15 minutes to pull the files from sharedrive. I assume that once I will move this to Server, then the time to pull these files will increase might increase depending on the internet speed and bandwidth . So, I was thinking if there is a way to speed up this pulling part of input tool, so that this will take only a minute.

Hope this helps.

mathieuf · Answer

Hi @Rahul3,

How much time does your workflow take and what is the acceptable time for it to run and deliver results?