How to append the multiple excel sheet into one excel using altreyx

[MaheshR]

I am unable to append the attached Excel sheets to Altreyx.

[caltang]

This should help you https://knowledge.alteryx.com/index/s/article/The-Ultimate-Input-Data-Flowchart-1583459854309 

[MaheshR]

I am still unable to append the work sheet. Can you please show me an example with the work sheet I have provided. 

[caltang]

@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/

[Sangini]

1. Input Data Tool:

   • Drag an "Input Data" tool onto your workflow.
   • Configure it to read the first Excel sheet.

2. 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.

3. 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.

4. 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.

5. 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.

6. Run Workflow:

   • Click the "Run" button to execute your workflow.
   • Check the output location for the new Excel file containing all the sheets' data.

[caltang]

@MaheshR did my solution help?

[Deano478]

@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

[Sangini]

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.