Alteryx Designer Discussions

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

Change sheet name of excel files and combine

Dave
6 - Meteoroid

Hi all - very new to Alteryx but it is becoming invaluable already

 

I have a query, apologies if this has been posed before

 

1- I have a folder with a number of excel files

2- each of these excel files has a name

3- each file has a single sheet

 

I would like to

 

1- combine the files with one sheet , into a single file with many sheets, with each sheet taking the name of the file it was pulled from. 

 

 

Is this possible?

 

Thank you so much for any help you can provide

6 REPLIES 6

You could use the directory and dynamic input building blocks and ensure carry over the file name and then reuse it in output building block.

 

messi007
14 - Magnetar

@Dave,

 

Attached a zipped workflow 

I added a comments in order to explain what I have done.

messi007_0-1630056151520.png

below the macro 

 

messi007_0-1630056435269.png

 

 

Hope this helps!

Regards

 

Dave
6 - Meteoroid

Ok I think I need to simplify this a little. I have a directory and I am isolating a file containing the word allowance

 

Dave_0-1630066210476.png

I want save that file as a file called "Allowance", maintaining the data in the file. I dont need to delete old files. 

 

Dave

messi007
14 - Magnetar

@Dave,

 

You can add a block until done at the end and chose the file name on the formula tool.

You can find the bloc until done tool in the developer palette.

 

If this solve the issue please mark it as solved it will help others.

 

Regards,

Dave
6 - Meteoroid

I think I see my issue - Im using teh directory tool which is returning a list of files not linking the file I want to amend

 

Rhank you anyway

Labels