Anyone Else Ever "Lose" a Workflow?

Surely I and the creator of this idea are not the only ones who create a yxdb and then can't find the workflow used to create it.

There are an awful lot of ACES in this forum, who are probably dealing with dozens or hundreds of times the number of workflows I am.

So how do you keep track of them all, and what feeds into or feeds off of other workflows?

P.S. if you're in the same club as we are, kindly go star this idea to incorporate metadata in the yxdb to TELL YOU where it comes from!

http://community.alteryx.com/t5/Alteryx-Product-Ideas/Add-metadata-to-YXDB/idc-p/16459#M2154

Workflow

Tips and Tricks

Optimization

Accepted answers

MarqueeCrew

I have overcome this with the use of the mainframe. When I'm creating a production process, I like to name modules and datasets as though I were on the mainframe. I've modified the technique, but in short here is the way I know where a file came from:

100 CREATE [PROCESS_NAME] Data

110 UPDATE Customer File Data

etcetera.....

The output files might look like:

\100_Email_Hygiene.yxdb

\110_Cust_File_Update.yxdb

By using a # in the workflow name that matches to the # in the data, I can readily find the workflow.

OLD SCHOOL,

Mark

All comments

MarqueeCrew

100 CREATE [PROCESS_NAME] Data

110 UPDATE Customer File Data

etcetera.....

The output files might look like:

\100_Email_Hygiene.yxdb

\110_Cust_File_Update.yxdb

By using a # in the workflow name that matches to the # in the data, I can readily find the workflow.

OLD SCHOOL,

Mark

cbridges

That's a great idea for me going forward. I've actually used this method to some degree when I chain runner macros. I always rename the underlying workflows in numerical order of operations, and then name the runner tools similarly (001_Run ABC, 002_Run DEF, etc) which reallly helps when something under the hood goes wonky for some reason.

Wish I had been that smart to begin with...optimizing these best practices could be a pain.

But you did give me a couple of great ideas... I've been adding a datestamp in all my workflows that really doesn't do anything or connect to anything except ensure that my most frequently used workflows are also my most recent. But if I take on the project of thoughtfully renaming everything, then that would go a long way in making sure my greatest hits workflows are not only the most recent but are also more logically named.

I know what my first step will be... good old dos directory tree dump LOL. Talk about old school.

anthony

Because Friday... (this forum tool would be much better/easier if I could cut and paste images vs saving and uploading)

Yes I lose all kinds of stuff... alteryx to the rescue... again.

I modified the example workflow that count tools TO search all my XML for the query string "inventory" .... whether YXDB/MD/tool name etc.

The way this works - ListOfWorkflowFiles.bat builds a list of all *.yxm* files in specific directory's and then feeds each workflow/macro into batch macro that parses looking for the search term.

Batch file looks like this - probably not most efficient but im not in the business of writing batch files. it calls the DIR *.yxm* business and appends files to the CSV file from each directory.

Macro search box looks like this - i searched for inventory in ALL altreyx xml in the csv.

Which results in this.

This is the modify sample macro I used. The tumor looking parameter text box on the left of the filters is where the magic happens. It updates the Contains([Field_1],"soapenv") field so that it finds the search term entered in macro. As you can see this all started with me trying to find some soap modules I built.

This is not really a prime time level tool so I am not ready to share but if someone wants to take this to the next level, I applaud you.

TaraM

@anthony wrote:
Because Friday... (this forum tool would be much better/easier if I could cut and paste images vs saving and uploading)

Yes! This has been requested (http://community.alteryx.com/t5/Suggestions-For-Our-Community/Paste-images-directly-into-discussions/idi-p/13104#M92) and the feature is dependent on a partner. But feel free to vote on it!

A similar batch macro that is in the samples is the File Finder Batch Macro which will search for a datafile in a workflow. You can find it from the Help > Sample Workflows > Analytic Apps > File Finder. The macro looks like a pair of binoculars

2016-03-18 15_23_37-.png

2016-03-18 15_27_15-Alteryx Designer x64 - 14 File_Finder.yxwz.png

It may require a little fiddling to do exactly what you want, as that is the purpose of the samples, but I find Alteryx is very powerful in tracking down its own files or any other lost files for that matter!

Not to say your idea @cbridges isn't a good idea - I think it's great!

cbridges

Thanks @anthony! I'm not sure whether I can pull this off (I'm not that macro savvy), but it looks like it would work!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703