Access to filename in macro workflow

jeffv

Just thought maybe someone might have insight to something I need in a workflow...

Say I have a macro:

1: Macro input with file name

2: Filter

3: Summary

4: Table

5: Email

Is there access to the filename passed in to include in the email? By access I mean can I include in email the name of the file passed to macro?

Thanks!

Jeff

Input

Macros

Accepted answers

BenMoss

The reason this does not work is because you are using a 'macro input'.

In fact you want to use the 'control parameter'. The icons are very slightly different.

See attached.

Ben

Batch.yxmc

All comments

cmcclellan

Assuming that your macro starts like this, just change "Output File Name as Field" to YES

2018-06-09 07_55_03-Alteryx Designer x64 - New Workflow1_.png

BenMoss

Yes of course this is possible.

One of the options in the input tool is to 'Output File Name as Field'.

In your summerize tool and table tool be sure to 'group by' this 'FileName' field, which will then be passed to the email which you can then include as a field.

Have a go and let us know if you get stuck!

Ben

jeffv

So while I thought with the response you have given I thought I was good to go.... uh... not quite... You answers were right on and I'm able to see the file name and use it as needed. However, the bigger picture of the macro didn't quite go as planned....

From the driver program I am "passing in" the file name... I thought with macro input I could use the file name passed. (In my simple test I wanted to pass a few file names in, then the macro would grab the name open the file do a filter on a particular sheet, summarize and get count of rows, then send an email to me with filename and count.)

I'm not understanding how to get the macro input to used the file name passed from the driver. Maybe I'm using wrong type of macro? I was using batch macro. Below is a snapshot of macro.

Any hints?

Jeff

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703