Replace Cells on a Specific Tab within a Directory of folders?

Question

Hey,

I have a directory of folders that contains subfolders and excel files with different names and content.  However, *almost* all files within this directory contains a tab titled "Parameters." This Parameters tab only contains roughly 10 populated cells that then link through the file.

As these parameters are updated on a monthly basis, I would like to be able to replace these cells within the "Parameters" tab with the new parameters, as well as the tites of the files, as they each contain the parameters as well.

An help is greatly appreciated!

pedrodrfaria · Answer

Hi @Boston95

I attached below an example using a directory tool and a couple of macros to read all the sheets from multiple files, filter by the ones you want and load them so then you can manipulate them.

Replace Cells on a Specific Tab within a Directory of folders.yxzp

New Microsoft Excel Worksheet.xlsx

mbarone · Answer

You can use the Directory Tool to get the file name and paths of all the Excel files.  You can then use a formula tool to add the tab name to create a full path up to the tab. Then you can read them in using a Dynamic Input tool, make whatever changes you want in Alteryx, and output the results however it fits.

But first, familiarize yourself with the Directory Tool - then the Dynamic Input tool.  The Tool Mastery Index (https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Index/ta-p/84593) is a great place to start.