Take analytic app chosen field and prefix it to outputted file name

[wonka1234]

Hi,

I am trying to make the input typed in by someone to append to the beginning of a file.

Ie if a user types in 202211 the output file name will be  202211_test.xlsx ,  if its multiple dates, make it 202211_202212_test.xlsx

can this be done? 

see attached workflow.

[DataNath · Accepted solution]

Hey @wonka1234, here's one way you could do it:

1) Add a bit of dummy text to your output file name that will be replaced on a real run (ABC here):

2) Add another Action tool to your Output Data, which replaces this 'ABC' with your list of dates - the nested Replace() is to swap commas for underscores so that if the user types '202211,202212', this becomes '202211_202212' as mentioned above:

3) Now if I run this:

Hope this helps? Let us know if not!

[binuacs]

@wonka1234 another method of doing this

[wonka1234]

@DataNath thanks! if i wanted a second filter to be appended? ie

202211_202212_jon_test.xlsx

[DataNath]

@wonka1234 just apply the same principle again - set up your Output to be something like ‘ABC_XYZ_test.xlsx’. The first Text Box input that we dealt with earlier, set that up to change the ‘ABC’ part, and then set up the second (name) filter to replace the ‘XYZ’.