Create New with date and time, when workflow is run

BRRLL99

Hi Team

I'm looking to create new excel file with single sheet whenever the workflow is run

ex:

If i ran the workflow at 07-11-2023 5:00 PM

file should be created as sample 07-11-2023 5:00 PM

I have ran the same workflow at 07-11-2023 5:10 PM

file should be created as sample 07-11-2023 5:10 PM

Sample file has been attached please look into it

Sample - Superstore.xls

Data Investigation

Accepted answers

mceleavey

Hi @BRRLL99 ,

As @alexnajm mentioned, you need to create a formula which will append the formatted datetimenow() function to the name of the sheet.

You then need to consider the output hitting the same file (potentially) at the same time, and so I've used the new Control Container functionality to control the sequence.

If you do not have the latest version of Alteryx then you'll need to build the batch macro output method.

Screenshot 2023-07-11 141253.png

I've attached the workflow.

I hope this helps,

mceleavey solution.yxmd

All comments

alexnajm

It would be a Formula tool creating the path you would want to write it to! I am not sure the folder or extension, so here's an example that will just save to the same location as your workflow:

"sample "+DateTimeNow()+".csv"

If you want to format the current time, surround the entire thing with DateTimeFormat and specify your format with these specifiers: DateTime Functions

mceleavey

Hi @BRRLL99 ,

As @alexnajm mentioned, you need to create a formula which will append the formatted datetimenow() function to the name of the sheet.

You then need to consider the output hitting the same file (potentially) at the same time, and so I've used the new Control Container functionality to control the sequence.

If you do not have the latest version of Alteryx then you'll need to build the batch macro output method.

Screenshot 2023-07-11 141253.png

I've attached the workflow.

I hope this helps,

mceleavey solution.yxmd

ahsanaali

See if this works for you.

Note: cannot use colon (:) in the file name.

Create_new_file_with_date_time.yxmd

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335