Dynamic input to a batch macro

[Sshasnk]

So I want to create a batch macro that consumes different files and opens it inside the batch macro.

Example: 

1. Use the directory tool to read all the data from the folder and the data folder inside a folder (By checking Include subdirectories).

    Output after the first step:

Fullpath

C:\program\ML\Test.csv

C:\program\ML\Json\Test1.csv

2. After getting the above Fullpath I have to push this into a batch macro and open it in Two different input tools.

Note:

1. Both the file have different schema 

2. We have to only use one directory and segregate both the files and open it inside a macro 

Let me know if you have any doubt

[gautiergodard]

I believe the attached workflow is what you are looking for. You can update the directory tool to point to the folder path where your files are stored. You will also need to update the dynamic input tool to extract all of the tab names in your excel (if you're inputs are excel) - for CVS this step will likely not be necessary. You can send pass the full path through the macro tool which will help you bring the data into Alteryx. 

**Please like and mark this solution as complete if this solves your issue**