Opening multiple text files located in a folder

[JohnLight]

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?

[binuacs]

@JohnLight Directory tool is one option to read all your files from the folder

[ArtApa]

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/249...

[JohnLight]

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.

[JohnLight]

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?

[ArtApa]

@JohnLight - Have you configured your Dynamic Input? You need to connect it to one of your text files first:

[mceleavey]

 @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-in...

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.

[JohnLight]

I don't have a test connection option.