How to append the multiple excel sheet into one excel using altreyx
- 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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This should help you https://knowledge.alteryx.com/index/s/article/The-Ultimate-Input-Data-Flowchart-1583459854309
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am still unable to append the work sheet. Can you please show me an example with the work sheet I have provided.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@MaheshR I followed the link I sent you in its exact manner and got it done. Please try this and study the process - it will help you a long way in your Alteryx journey.
If the above solved your need, kindly like & mark as accepted solution so that you may help others find the solution more quickly + to close the thread as is. Thanks!
Best regards,
Calvin Tang
https://www.linkedin.com/in/calvintangkw/
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Input Data Tool:
- Drag an "Input Data" tool onto your workflow.
- Configure it to read the first Excel sheet.
Input Multiple Files Tool:
- Drag an "Input Multiple Files" tool onto your workflow.
- Connect the output anchor of the "Input Data" tool to the "Input Multiple Files" tool.
- Configure the "Input Multiple Files" tool to read the rest of the Excel sheets.
Select Tool:
- Drag a "Select" tool onto your workflow.
- Connect the output anchor of the "Input Multiple Files" tool to the "Select" tool.
- Open the "Select" tool's configuration and make sure you have all the necessary fields selected.
Union Tool:
- Drag a "Union" tool onto your workflow.
- Connect the output anchor of the "Select" tool to the "Union" tool.
- The "Union" tool will automatically combine the data from all sheets.
Output Data Tool:
- Drag an "Output Data" tool onto your workflow.
- Connect the output anchor of the "Union" tool to the "Output Data" tool.
- Configure the "Output Data" tool to save the combined data to a new Excel file.
Run Workflow:
- Click the "Run" button to execute your workflow.
- Check the output location for the new Excel file containing all the sheets' data.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@MaheshR did my solution help?
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Sangini While chat GPT is great please try not to just copy and paste text from there as an answer, as the answer you provided clearly is AI generated
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello, So understand this in easy language.
Alteryx acts like a superhero, which helps to combine data from different Excel sheets into one. Here are some steps which we are following.
--> Open Alteryx
--> Then, drag an "Input Dat" tool onto your workspace.
--> Add Excel files where your data is stored.
--> Use of the "Union" tools, which helps to merge everything.
--> After this connect the input tool to the Union tools. ( This helps Alteryx to know where to get the data from)
--> Click on the Union tool and make sure everything matches up. ( So Alteryx knows how to combine the data)
--> Then, you bring in an "Output Dat " tool. ( Which is to tell Alteryx, where to put the combined data)
--> Click on the Output tool and choose where you want to save your combined or new Excel file.
You can also check this: https://knowledge.alteryx.com/index/s/article/The-Ultimate-Input-Data-Flowchart-1583459854309react native
I hope this information will help you.
![](/skins/images/1AD6617C767659D8A9F9801BEDFCFB20/responsive_peak/images/icon_anonymous_message.png)