Dynamic input tool

jonathanogrady

Hello fellow Alteryx fans!

I'm trying to use the dynamic input tool to upload hundreds of text files, but I'm hitting a brick wall for some reason.

Each of the text files is located behind an individual zip file. So the typical format would be:

Directory\file_1.zip -> file_1.txt
Directory\file_2.zip -> file_2.txt
Directory\file_3.zip -> file_3.txt

I am using the directory input tool to target the specific folder. How should I configure the dynamic input tool to download and join each of the files which are in exactly the same format?

As always, community help very much appreciated!

Best wishes,

Jonathan

DavidP

Ok, so here's how I do it:

From the Directory tool output, use a Select tool to remove everything except [Fullpath] and [Filename] - this step is not strictly necessary.

You now have to update [Fullpath] to look like below. I did it by replacing the 'zip' in [Filename] with 'txt' and updating [Fullpath] with the formula:

[FullPath]+'|||'+[FileName]

Now you can use [Fullpath] as the input field for the dynamic input tool.

See workflow attached.

dynamic input zip files.yxmd