Import multiple Excel files and run workflow separately for each with separate outputs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks for your response. How do I create this iterative macro? Sorry, I'm relatively new to this
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
