Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Append Input Date to Output File name

areeba
8 - Asteroid

Hi ,

 

Is it possible to take date from input file/source file and append it in the Output file ?

For eg:

Input File name is : 'Orange- Fruits and Vegetables(weekly) - Organic Farm Land 2020-09-30  _08_03 CEST.xlsx'

 

 

My output file name should be like this:  'Fruits Overview 2020-09-30'

Regards

Areeba

20 REPLIES 20
areeba
8 - Asteroid

Hi @atcodedog05 

 

areeba_0-1606143703781.png

It is coming NULL

 

atcodedog05
22 - Nova
22 - Nova

@areeba  can you show me date column.

areeba
8 - Asteroid

Hi @atcodedog05 

areeba_0-1606144051174.png

 

atcodedog05
22 - Nova
22 - Nova

hmm thats strange. Use this formula in date formatted formula.

 

Right([Date],7)

 

and show me date formatted column.

areeba
8 - Asteroid

@atcodedog05 

Yeah , it is strange. Now i am getting this

areeba_0-1606144321182.png

 

atcodedog05
22 - Nova
22 - Nova

perfect we are close. change the date formatted formula to this

 

TrimLeft(Right([Date],7),"-")

 

areeba
8 - Asteroid

@atcodedog05 

 

Bingo !

but I also need to put '0' if month is single digit like here '09-2020'

atcodedog05
22 - Nova
22 - Nova

Try this formula in date formatted

IIF(Contains(Right([Date], 7),"-"), "0"+TrimLeft(Right([Date],7),"-"), Right([Date],7))
areeba
8 - Asteroid

@atcodedog05 

It Worked...😁

 

I hope it will take care when month become double digit , then it should appear 12-2020 not 012-2020..just getting sure😋

atcodedog05
22 - Nova
22 - Nova

@areeba Finally we solved it Hi-Fi🖐

 

Happy to help 🙂

 

Cheers and Happy Analyzing 😀

 

Feel free to reach out if you face any issues 🙂

Labels