Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Add latest date while using Output Password Protected XLSX

tanvir_khan
8 - Asteroid

Hi all:

 

I'm using Output Password Protected Excel macro to protect output excel file but this tool takes fixed file name. I need to add current date with file name. Is it possible to set filename dynamically to this tool? Appreciate if anyone let me know please.

tanvir_khan_1-1618542480295.png

 

tanvir_khan_0-1618542312891.png

Thanks!

1 REPLY 1
mceleavey
17 - Castor
17 - Castor

Hi @tanvir_khan ,

 

As with all tools, if you want to make one of the fields dynamic you can simply put the last tool in a macro and feed the sheet name in as a batch parameter to update that field.

 

mceleavey_0-1618565975190.png

Then simply save this as a macro, add it to your workflow to replace the output tool, then set the batch parameter to be the filename (you might want to group by this field first).

 

M.



Bulien

Labels