Dynamic Input Error

[vipul_2710]

While working with workflow to append the files together.. I am getting the below error

The Directory tool outputting all the three files but they are not getting read in dynamic input file... 

[ChrisTX]

Are all of the input sheets in the same format?  

If any sheet has a different format, try the batch macro in this post:

The Ultimate Input Data Flowchart

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/t...

Option #3 Batch Macro with file paths

ATTACHMENTS: Batch Input.yxzp

[vipul_2710]

Hi Chris,

My all files are same.. I have attached the workflow with all the files for reference.

[ChrisTX · Accepted solution]

In the Directory tool, if all files in the folder are XLSX, no changes are needed.  If any file is not XLSX, change the file spec to *.xlsx

In the Dynamic Input tool, change the Action field to "Change Entire File Path"

Chris