Tool Configuration to Generate a File Name

Question

So I've created a workflow that copies columns over from one excel workbook and the final step is pasting those columns into a new workbook but the catch is that new workbook needs to have a specific name based on the current Fridays date ex. (" ACH Import 06092023")

jdminton · Answer

@binu_acs idea is great. To build on that, if you use the directory tool when pulling the file in, you can get the created date and either use that directly in the filename formula or create a formula to calculate the previous Friday (or next) depending on your need. Also, if the file you are inputting already has the date identified in its name, you can check the box on the input config to "Output File Name as Field" and use substring() or RegEx to identify the date in the filename.

binu_acs · Answer

@aogle3497 Create a File Name variable like the one below in the formula tool and update the output tool

Specific_FileName_090623.yxmd