Free Trial

Alteryx Designer Desktop Discussions

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

Dynamically Renaming

mbraunSFA
6 - Meteoroid

Is there an easy way to rename an input file once the workflow is complete....?

 

For Example:

INPUT_FILENAME  WORKFLOW  1. OUTPUT_FILE 2. INPUT_FILENAME_YYYY_MM_DD.DONE

1 REPLY 1
kat
12 - Quasar

Hi @mbraunSFA

 

This is a tiny bit trickier but totally doable. You need to use the command tool to move and rename your file. This can be executed from within your workflow. The attached should give you an idea how this works. 

 

First I removed the sheet name from the file path - this isn't part of the rename.

In the NewFileName formula you can edit the name of how you want your file to be called. You can use a datetime formula, etc here.

We then build our command. We take our file and move it from it's original location to the new one. The directory can stay the same, or you can also move your completed files to new folders.

We then execute the command. The tool first updates the batch file with the command you just created and then moves it to the new name.

 

Please let me know if you need more help!

Kat

Labels
Top Solution Authors