Change Input Tool directory based on user input. Import .XLS files with multiple sheets.

I have a workflow that looks like this (followed by a bunch of data cleaning - this is dirty data). There are ~20 files in a given directory, each has 4 tabs with an identical schema. I've been playing around with Dropdowns and Actions, but I am struggling to make this more dynamic. I would like to take the [currently static] input directory and make it more dynamic by replacing a part of the file path from a user selected input. I.e. if this is the file path: \Documents\UTN Dashboard\Raw Data\FY20\2019.10\*.xls, I want to replace the 2019.10 with a different string.

Any suggestions?

Input

Accepted answers

DavidP

Something like this should work for xls files.

Download the attached workflow package file, change the extension to zip and unzip the file. Now edit the Alteryx App file in a text editor and change the version

You have to pre-populate the text input tool with your sheet names. You'll then have to change the template file in the dynamic input tool.

Folder browse to load multiple sheets from multiple files.yxzp

All comments

DavidP

This is how I would do it. If the files don't all have the same schema, I would change the dynamic input tools for batch macros

Folder browse to load multiple sheets from multiple files.yxzp

271828

David,

Thanks for the reply. I've downloaded your workflow and am about to test it out once my Designer updates to the latest version.

One thing I forgot to mention is I'm dealing with .XLS files, which may create an issue with your answer (List of Sheet Names). In my experience so far, .XLS files don't play very well with Alteryx. That's why I created a rather basic workflow to import them - despite reading almost every XLS input question I could find, there doesn't seem to a be more elegant solution that is easy to implement.

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262

JORGE4900 235