I'm trying to read in data from multiple documents that are all located in a single folder on my computer. Does anyone know which tool I can use to open them in Alteryx without having to pull them in individually?
@JohnLight Directory tool is one option to read all your files from the folder
Hi @JohnLight - You will need both Directory and Dynamic Input tools. Please read the following article and review Sample Workflows to learn how to use them: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Dynamic-Input/ta-p/24946
With the directory tool, it only allowed me to view the files and it's metadata, but I couldn't get the contents of the files.
I'm getting an error: " Dynamic Input (32) Error opening the file "*file path*": Access is denied. (5). Do you know how to fix this?
@JohnLight - Have you configured your Dynamic Input? You need to connect it to one of your text files first:
@JohnLight ,
You can read a walkthrough of this scenario in this thread:
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Multiple-files-with-multiple-sheets-into-one-file-with-multiple/td-p/723634
This also has my post with the dynamic tools that will do it all for you, and will bypass the problem of multiple schemas which will inevitably occur.
I hope this helps,
M.
I don't have a test connection option.
