I have an alteryx workflow I inherited that is used monthly for company metrics. For the most part, I run a handful of reports, refresh xlsx and csv files in the input folders, run it, then refresh dashboards and spot check for inconsistencies.
I ran into something new today as I was trying to put data from a few months ago in to clear up some issues - I get an error at the macro:
Record #1: Tool #2: Unable to open file for read: C:\Users... and then my username, One Drive, and the file path
So I went into the macro, ran it, and the error occurred at the input tool, with Can't Find the File, with the entire path including my username, etc.
However, on the input tool in the macro under Connect a File or Database - it's just the direct path the the file from the directory the workflow and macro are in (down 2 folders then to the file)
I know the path is correct, I've copied it back over from explorer, but trying to refresh doesn't give me anything. I thought it could be the file name (this macro is to aggregate a folder of files with a strange data structure), but that shouldn't matter, because right before the macro is a Formula tool that creates field FilePath as "\folder\"+[Filename]+"|||'Data Tab$'", so the filename should be irrelevant as long as the tabs are correctly named, which I've checked.
