In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Data input

Bakiyaraja
7 - Meteor

, I am looking for solution for below problem I have 5 excel files that are all different in structure/schema • 2 files have 10 column, • 1 file have 8 column • 1 have 16 column • 1 have 4 column and I need to merge in single excel with five different sheets could you please help me or share sample workflow it would be helpful

15 REPLIES 15
binuacs
21 - Polaris

@Bakiyaraja wanted to check whether the given workflow working for  you or not?

Bakiyaraja
7 - Meteor

 HI Binuacs ,Thanks for follow up  YOU REACHED ALMOST 90 % the but problem still exist in the workflow , if the number is column in the sheet is different /or when we gave 3 input with different schema.

 

please find the output after macro 2 :

Bakiyaraja_0-1658125959245.png

 

i am still looking but not able to solved,could you please help to solve 100% 

Please find the attached input sheet.

binuacs
21 - Polaris

@Bakiyaraja Can you try the attached workflow and let me know

 

binuacs_0-1658132047922.png

binuacs_1-1658132067709.png

 

binuacs_2-1658132086516.png

 

binuacs
21 - Polaris

@Bakiyaraja just checking whether the updated workflow working for you or not?

Bakiyaraja
7 - Meteor

@ Binuacs Thank you for everything you do. The solution you provide help me to solve the problem.

 You have been most helpful. You have my gratitude.

binuacs
21 - Polaris

@Bakiyaraja @I’m really glad to know that the solution worked for you!!!

Labels
Top Solution Authors