I have a situation where I have people downloading text files from a state agency and then importing them into an Access database. They have to go through a bunch of steps every time, from setting the delimiter ( a tilde ~ ) to column data types to renaming an existing table with the date appended so they can "go back in time" if need be.
Even on a perfect day this can be error-prone, due to the number of repetitive user actions. But sometimes Access refuses to read the files, even though nothing appears amiss.
And then Alteryx walks into the room.
I took one of their problem files and crafted a sweet solution that reads the existing table, saves it back in with the current date appended to the table name, reads the file, cleans up the datatypes, and overwrites the existing table.
Now what I want to do is create an app and place it in our Alteryx Gallery. But I'm getting an error from the Action tool when I navigate to the same file I've been uploading and testing with during development.
Input Tool Configuration
File Browse Interface Tool Configuration
Is there anything I can do to tell the Input Tool to just read the file regardless of what it thinks?
Thank you for your time.
Sincerely,
David
