Alteryx Designer Desktop Discussions

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

Merging multiple excel sheet according to their header name.

Ekmi9
8 - Asteroid

I have one folder which contain multiple excel files and each excel file have multiple sheet i want to merge that excel files according to sheet name and also header name. can somebody help me this issue ?

 

Thank you in advance! 

9 REPLIES 9
atcodedog05
22 - Nova
22 - Nova

Hi @Ekmi9 

Can you provide some sample input and expected output It will help us get a better understanding of the usecase.

We will be happy to help : )

Ekmi9
8 - Asteroid

Below attached sample input and excepted output i have one folder that contain "N" multiple excel file which not fix every time.  

 

atcodedog05
22 - Nova
22 - Nova

Hi @Ekmi9 

 

can you provide this excel file attached.

Ekmi9
8 - Asteroid

Yes 

atcodedog05
22 - Nova
22 - Nova

Hi @Ekmi9 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1645001611714.png

 

Hope this helps : )

 

Ekmi9
8 - Asteroid

Can you please share the configuration of macro and i am getting this error while running this workflow.

 

Ektaoza9_0-1645001840508.png

 

 

atcodedog05
22 - Nova
22 - Nova

Hi @Ekmi9 

 

You can ignore those. These are not required assets. You can just take the macro and build the workflow in a similar way.

 

Hope this helps : )

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @Ekmi9 

Cheers and have a nice day!

Ekmi9
8 - Asteroid

@atcodedog05 thank you :)

Labels
Top Solution Authors