Change sheet name of excel files and combine

[Dave]

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

[Prashant Chamarty]

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.

[Prashant Chamarty]

@Dave accidentally deleted my comments few articles which might help you

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Import-Multiple-Excel-Sheets...

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-to-Input-Multiple-Sheets-from-M...

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Read-in-Multiple-Excel-Files-with-M...

[messi007]

@Dave,

Attached a zipped workflow 

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

below the macro 

Hope this helps!

Regards

[Dave]

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

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]

@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 · Accepted solution]

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