This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
My workflow takes data from about 20 seperate input files that are identically formatted and different only by the name of the file (each file has a distinct name, i.e. "Widget #1," "Widget #2" etc.) and each file is fed into a seperate and (nearly) identical workflow box which are joined at the end into a single output file consisting of 20 rows of data, one row for each "Widget" and some data columns going across (weights, cost, etc).
The hassle i'm having is that in order to get the output file to name each row for each individual widget, i have to manually change 2 formula tools in each workflow box (20 times) with the name of the seperate widget from the input files. is there some way to incorporate into the workflow the names of the individual files so that each box will take the name (or portion of the name) of the file rather than this manual change in the formula tools in each workflow?
Thanks Ladarthur, that did the trick. Now for another question - is there a way to import multiple input files into your canvas at once? I'm putting in 20-30 files on my canvas one at a time, there's got to be a quicker way - tried to copy paste but the tool wouldn't do it.
Thanks Thableaus. Another hassle: when I get my 20 files onto my canvas i have to to two sets of very manual actions:
1. I have to set up each input option one at a time (i.e. "Output File Name as Field" and "Start Data Import on Line...") is there any way to set my options all at once for all the files, rather than 20 separate times?
2. I have to manually bring each individual file to the next tool (i.e. "Data Cleansing") and do this 20 times to 20 identical tools. Is there a way to bring them all to the SAME tool at once, so that I am combining all the files into a single data set to work on?
I've played around with the "Directory" tool and the "Dynamic Input" tool but either i'm not using them correctly or they're not designed to handle these actions.
It depends on how the schema of your files is set.
If the 20 files have the same columns, same metadata and all, you can use the Dynamic Input + Directory Tool option. Although you'll need some additional configuration if you have an irregular sheet composition (e.g. Your table starts at Row 5 in Excel)
Other than that, you can do some XML hacking of your workflow to set up all these configs at once.
If you're still beginning to use Alteryx, I recommend you to look up some resources to understand these options (for example, parsing the XML of a workflow can be tricky).
When setting up the parameters of the input tool you can choose "Output File Name as Field" to add the file name as a field. is it possible to do the same with a tab name in your file? It would definitely be easier for my process to use one input file with multiple tabs of differing names than multiple input files of one tab each. Any suggestions?