Import multiple Excel files and run workflow separately for each with separate outputs

Hi all,

I am trying to import multiple files (same format and structure) and want Alteryx to import all of them and run the workflow for each of them separately. It should treat each file as a separate file. Once done, it should produce the outputs for each file separately with filename based on one column.

I don't want Alteryx to combine them or mix any of the data, just that the workflow is same for each file, I don't want to run it for each file separately.

Please help, thanks in advance.

Datasets

Input

Output

Custom Tools

Dynamic Processing

Database Connection

Accepted answers

Qiu

@Ronak_Kothari
Maybe you can search the material in this community for how to make iterative or batch macro. they are very helpful.

Anyway, I made a sample one and hope it would help.

0319-Ronak_Kothari.yxzp

All comments

Qiu

@Ronak_Kothari
I beleve this can be achieve as below

1. use a directory Tool to read the full path of all files need

2. The full path will be parameter filled into an iterative macro.

3. inside the macro, the data will be read in for each time and output the desired the ouput.

danilang

Hi @Ronak_Kothari

As @Qiu mentioned, you can use a batch or iterative macro to accomplish this, but you can also do this within a regular workflow by making sure that the filename is returned and that you apply grouping operations in your calculation and output tools using the filename as a key.

So my question is why do you want to batch this process?

Dan

Ronak_Kothari

Thanks for your response. How do I create this iterative macro? Sorry, I'm relatively new to this

Qiu

@Ronak_Kothari
Maybe you can search the material in this community for how to make iterative or batch macro. they are very helpful.

Anyway, I made a sample one and hope it would help.

0319-Ronak_Kothari.yxzp

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167