Output with Month Number and Year

[Karthick461]

Hi,

 I have created Alteryx Workflow as Interface ( Analytic App ). when I execute the WF , its asking Input Path and Output Path as per my design. But is there any way we can get the output with month.No and Year prefix to it automatically based on the Posting date which I am selecting from the Interface. Posting Date is one of the Field in my input.

For ex. If I choose 07/01/2021 to 07/31/2021 as my posting date , my output needs to be \\chennai\newfiles\07_2021_result.

If I choose August means, output needs to be \\chennai\newfiles\08_2021_result ( without deleting other files)

[Luke_C]

Hi @Karthick461 

Here's a simple example of how to parse this information out of the date field to create a file name. You should be able to leverage this in your workflow. Hopefully this gets you in the right direction.

[Karthick461]

Hi @Luke_C ,

 Sorry. I have my Posting date as 07/20/2021 ( MM/DD/YYYY format ) . I modified your formula to achieve , but its still not working.

 Since MM/DD/YYYY format is acceptable here , do we have option to get month name and year from this format

[atcodedog05]

Hi @Karthick461 

I dont think / is supported in filename you would need to go for something like MM-DD-YYYY

Hope this helps : )

[atcodedog05]

Hi @Karthick461 

You can create like these

Hope this helps : )

[Karthick461]

Do we have option to Ignore date(31) at result . Reason because of , I will run for all 30 days in single shot. 

Instead of getting 30 output files, I would like to get one output for all dates in one month

[atcodedog05]

Hi @Karthick461 

Here is how you can do it. When you select a date it takes all 30 days in the month and excludes 31

Workflow:

Hope this helps : )

[Karthick461]

Hi @atcodedog05 ,

 Sorry for the confusion. In my earlier chat , I asked to ignore date(31) . which means I dont want to see the date(any date) in output. 

 I want to see output as 08_2021_result. not like 08_01_2021 and 08_02_2021.

I have POSTING date as MM/DD/YYYY format

[atcodedog05]

Hi @Karthick461 

Are you looking for something like this? If not please provide sample input and expected output.

Hope this helps : )

[Karthick461]

I will try this and update you @atcodedog05