community
cancel
Showing results for 
Search instead for 
Did you mean: 

Detroit, MI

A networking group for Alteryx data artisans in The Great Lakes State.

Detroit, MI User Group Leaders:

Mark Frisch, Marquee Crew

Welcome & Guidelines

Find tips to make the most of your User Group experience.

LEARN MORE
Reply
This is an open group. Sign in and click the "Join Group" button to become a group member and start posting.
Highlighted

Alteryx Cross-Reference Input/Output Tool

Meteor

 Hi Community Friends,

 

In other programming environments, I had access to a list of

Filename, Program Name, Input or Output Indicator

 

 

I modified a macro a while back to serve this purpose for our Alteryx workflows.

 

The workflow calls the macro, which reads a file called "Cross-Reference List*.xlsx"  It has a header of "file_path" and it contains the list of workflows you are interested in finding input and outputs.

 

It outputs a file called "Cross-Reference.csv" with the above mentioned fields, specifically I called them:

Filename, Workflow, InOut

 

Most of our use case is regarding .xlsx files, I'm not 100% sure how this will scale to other inputs and output types.

 

I have found this helpful, and I thought I would share it with the community.