Date to File Name

[dkma]

How to add the Month Name, to file name with out using a Formula , or without including it in the File Data. 

Kindly Help

[atcodedog05]

Hi @dkma 

I dont think so its possible without formula tool. You need formula tool to prepare the filename.

[dkma]

Ofcourse I agree!, But I dont want that column to be in the file data

[phottovy]

Hi @dkma ,

I think this will be challenging without using some sort of formula option. Can you explain why this isn't an option?

For the second part of your question, you can accomplish this by unselecting the "Keep Field in Output" option on the Output Data tool:

[atcodedog05]

Hi @dkma 

@phottovy  covered it to not keep filename in data just uncheck "keep field in data" option in output tool.

Hope this helps : )

[dkma]

Hello @phottovy 

Confidential!, But we directly send the file to some other team with in our org, If we include one extra column in the file, They'll cry and shout. 😛 😛 :p. 

[atcodedog05]

I can relate to that @dkma especially when it looks like something cryptics 🤣

[phottovy]

I can definitely relate to that as well. Did this give you what you need? If so, can you mark the solution as completed so others may find it?

[dkma]

Hi all, The Excel file name is not changing!, the sheet name inside an excel sheet is getting changed!

[phottovy]

Take a look at this post: Solved:Dynamically change file name and output to different tabs 

It has an example that updates both the filenames and sheet names inside each file.