How to use a cell value in DirectoryTool?

Question

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!

jpscoralick · Answer

@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!

grazitti_sapna · Answer

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

MultiPathFileRead.yxzp

MultiPathFileRead.yxmd

MultiPathReads.yxmc

Luke_C · Answer

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)