read multiple files in box

[anutakki67]

Is there a way to read multiple files in the box folder using a keyword simultaneously?

[Raj]

@anutakki67 

Yes, in Alteryx, you can read multiple files from a Box folder using a keyword by combining the Directory Tool and Wildcard Filtering. Here’s how:

1. Directory Tool: Connect the Directory Tool to your Box folder's local sync path. This tool retrieves a list of all files within that folder.

2. Filter Tool: After the Directory Tool, add a Filter Tool to narrow down files using the keyword. You can set a condition on the "FullPath" or "FileName" fields to include the keyword

3. Dynamic Input Tool: Connect the filtered output to a Dynamic Input Tool. Configure it to read each file path from the directory list and bring them into the workflow.

[OTrieger]

@anutakki67 

If you the text will be static and will not change, then you can set it in the Directory tool and only the files that containing that text will flow in the work flow. If you will want to have a dynamic way you can use the above solution by @Raj 

[anutakki67]

Thank you, Raj, for a detailed step by step process. I am trying to read PDF files and noticed dynamic input does not have .pdf file format.

[apathetichell]

You cannot use dyanmic input and must use a batch macro. your pdf processing should be done in your batch macro for each file. you then union your outputs together via macro output. you must do your pdf processing in your batch macro though.

[nagakavyasri]

@anutakki67 You need Alteryx Intelligence Suite to read PDF files. PDF files cannot be read from Input tool.