Alteryx Help - Running Workflow and joining multiple Excel files into one
- 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, I'm fairly new to Alteryx and was looking for some help with an issue I'm running into. I have 10 different Excel files with similar formatting that I need to clean up and join into one sheet. I have created a Workflow that can successfully clean up one Excel file (filtering some data, making a new column, deleting some rows, etc.) but was wondering if there was a way to now create some Macro to rerun this for all 9 other Excel files and then join them into the same sheet. Note: I want to run the data cleaning script before joining the files. Thanks so much in advance!
- Labels:
- General
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Bill_2000123 ,
keep all the file in one folder then connect the that folder with directory tool. there you will see file specification option type excel extension *.xlsx and they run. in that way you can read all the file in one go, further you can do data cleaning process.
