Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Merging multiple excel sheet with different schema

hiteshnpwc
8 - Asteroid
‎07-04-2023 10:27 PM

Hello Everyone,

 

I am trying to merge the same Excel file with multiple Excel sheets with Different schema. I used the dynamic input tool to merge, however, due to a different schema it is getting failed. Data should be merged under a single header and different columns should be added in the sheet with null values if they are missing in other data.

 

Need your advice to complete this.

 

Thanks in advance. Attached is the sample data.

Preview file
44 KB
Labels:
Reply
0 Likes
2 REPLIES 2
messi007
15 - Aurora
15 - Aurora
‎07-05-2023 01:18 AM

@hiteshnpwc,

 

Please take a look on this post : https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Knowledge-Base/The-Ultimate-Input-Data-Flo... 

 

Hope this helps!

Regards

Reply
0 Likes
ed_hayter
13 - Pulsar
‎07-05-2023 01:32 AM

Hopefully this works - although I expect given the structure of your headers it will perhaps need more prep work?

 

Excel Sheet Batch Macro.png

Input Excel Sheets with Different Schema.yxzp
Reply
0 Likes
Copilot AMA
License admin COmmunity Live
Labels
Top Solution Authors
View All