How to use a cell value in DirectoryTool?

[jpscoralick]

Hello everyone!

In the middle of my workflow I have a field with some file paths, as shown in the image below.

Is it possible to use the 1, 2 and 3 lines, from FILE PATHS field, as the input of 3 different Directory Inputs, for example? 

I need to read some files that are located in those paths.

Thanks in advance!

[Luke_C]

Hi @jpscoralick 

Yes, you would pass these as the control parameter to a batch macro:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Getting-Started-with-Batch-Macros/t...

[jpscoralick]

@Luke_C , thanks a lot for the quick and useful answer!

[jpscoralick]

I still can't understand how I can set a input to Directory Tool, once it does not accept any input.

Could someone help me, please?

[Luke_C]

Hi @jpscoralick 

Are you referring to inputting data following the directory tool or after the directory tool itself? Once you get the file names from the directory tool you could pass those into a dynamic input tool or batch macro (there should be examples of that in the link I shared earlier)

[grazitti_sapna]

@jpscoralick , Here is the complete workflow with macro. You can use this but you just need to change the input and set the locations as per your files. Sending the zipped file as well as macro and workflow individually just in case not able to open the zip file due to version mismatch.

[jpscoralick]

@grazitti_sapna thank you so much for helping me!. Gonna do some tests here with your files. Really appreciate it.

@Luke_C I'm referring to inputting data following the directory tool. I'm need to input the values of FILE PATHS column below, which actually are some directories on which I have to search for some files. Thanks again!