Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Add file name after input

wht822
7 - Meteor

Hello,

 

I am using a workflow that starts off with a directory tool and then a macro created by another user (that I cannot edit) that brings in multiple tabs from multiple files. I would like to know if there is a way to add the file name later on in the workflow for each record. Since I am not using an input tool, I am unable to append the file name at the beginning of the workflow. Below is a screenshot of the start of the workflow.

wht822_0-1606770444660.png

 

2 REPLIES 2
PhilipMannering
16 - Nebula
16 - Nebula

You can't edit because it's encrypted? That's a tricky one. I think you're best bet (if nobody has a better idea) might be asking the creator to include the option for outputting the filename. This can be reasonably easily done. An example is attached.

PhilipMannering_0-1606772130885.png

 

HomesickSurfer
12 - Quasar

Hi @wht822 

 

Embed the encrypted macro that doesn't output the filename into another macro like below that reads in the fullpath from each record in your workflow.

In this macro, append the fullpath, get filename and output to your workflow.

Capture.PNG

Labels