Dynamically creating filename

Hi team,

I was looking to create a parameter which would take a string value from user and add that to the filename creation. (Dynamic way to do it )

Example :- I have Dev,Prod and Test regions and I am trying suffix a string to filename based on the region that I run the flow.

filename:- Cust_DEV_TimeStamp.txt or Cust_PRD_Timestamp.txt or Cust_TST_Timestamp.txt

Any help appreciated.

Workflow

Accepted answers

jdunkerley79

Add a drop down box from the interface tools and connect to a formula box

To keep it simple I used a fixed list of modes inside the drop down box:

On connected to a formula box (connect at the top) a new entry will appear in the variables tab of the formula tool:

You can then set up the formula to produce the required filename and add into the exisitng flow.

FInally save the workflow as an Analytic App:

All comments

jdunkerley79

In the output tool there is an option to take the file/table name from a field.

You can use an Append Fields tool to add a single field value to all rows and then this option would let you append a suffix to the filename.

If you want it in the middle as you showed then you would need to use a formula tool to create the required filename

Vamsee_kris

Thanks for your quick reponse .

But I want it to be added to the filename it does not come along with data from start . When I follow these approach I have to create 3 different fields and have three stings init like DEV,PRD and TST. at have to choose one everytime getting into flow.

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335