I have a working directory connection but don't know how to open each file in alteryx.
Dynamic input maybe?
I will later configure the workflow to pull the data with specific date (201809)
Instead of the Directory tool use an Input tool.
I would suggest reading the text files as CSV with no delimiter, but remember to up the length of lines.
Sample of what I mean attached
You could use a dynamic input but it is probably easier to use a normal input with wildcards.
Put in the path as \\....\Reports\*201809*.txt and it will read all txt files with 201809 in.
There is an option to include the filename in the output stream.
Which I did
The issue is how to open these files so I can see their content in alteryx.
