Hi everyone,
I am having an issue with Alteryx not being able to read my excel file. It keeps showing 0%. The file is only 10KB. I was able to run the whole workflow on Friday which took me 5 seconds.
Is anybody running into this issue?
Thanks
hi @SophieTran1
To debug, you can try to open a new workflow with only the Input tool.
if this persists, there can be a number of reasons, such as:
- The file setting is such that it does not allow the file to be programmatically accessed
- If you just download the file from somewhere and it is locked for Editing, you need to open the fil in Excel first and "enable editing" then save. There is another thread in the community discussion about Excel file access, you can check it out as well.
Dawn.
Thank you for the response.
I have been running this workflow couple of times. But this just happens today. And when I click the "Input", Alteryx was "not responding".
I tried open the input in the new workflow and got the same error. The excel file was not locked at all
if the input tool works file for all other excel file but only encounters an issue with this Excel file, perhaps the issue is with the Excel file being corrupted (i'm guessing).
Terrible isn't it since it looks like it is a recurring workflow for you... Can you try get another file (dummy shorter version with similar layout to try)? I'm not sure if that will help as I never encountered a similar issue.
It looks like it is happening with all excel file. The other file I have in the workflow is a CSV and working great.
I tried running a completely different workflow with different data and having the same issue
User | Count |
---|---|
108 | |
89 | |
78 | |
54 | |
40 |