Dynamically creating filename

[Vamsee_kris]

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.

[Vamsee_kris]

Thanks for your time and patience.

I got an thought here , can we do something we create Text Input dataset with  have drop down component it and select it as assign to field and run the flow???

[jdunkerley79]

You could do this as an analytic app with a drop down input that would do that.

Attached a really simple example

[Vamsee_kris]

This one seems to realistic , could help me with steps on how you created this.

Thanks in advance.

[jdunkerley79 · Accepted solution]

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:

[Vamsee_kris]

Hi jdunkerley79,

This is what I have done by looking at the steps 

1. Picked up drop down list (placed the values under it "DEV,TST,PRD)

2. Pulled formula box and joined it and save it as analytical app.

Still i am getting error missing saying incoming 

[jdunkerley79]

You need to add the data flow to the formula tool. This is just a formula to create a file name that an output tool can use to save the data to.