community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

how to add custom date column and join to the existing work flow

Hello,

 

I have a situation where i need to add a date manually every I run the workflow to the output. Can someone advise how to add a date which is of dd/MM/YYYY and connect to existing workflow?

 

Regards,

Satish

Asteroid

You need the date to enter into the data stream of the workflow?  If so, for this purpose, if it has to be manual, I'd probably use the text input tool. 

 

Either enter the date properly formatted in your required format, or just enter it as a string, make sure to format that field from that tool as string, then convert the field to the proper format downstream using either the Formula tool or the DateTime tool.

 

If I don't understand what you're trying to do here, can you clarify?

Bolide

@satishchaganti If this date is random (i.e. not consistent such as the current date, etc) then you can build an analytic app by adding interface tools. This would allow the user who is running the workflow to be prompted for the date value when the workflow is executed. This value can then be added as a column via the formula tool.

Alteryx Partner

In addition to @neilgallen's response, which I believe is the best solution if you want to be prompted for the date at run-time, youll want to add a Formula tool, or DateTime Tool to get the custom format you desire

 

In a Formula Tool, you can enter:

 

DateTimeFormat([Date], '%d/%m/%Y'')

 

For the DateTime Tool, you'll want to select the "Date/Time Format to string" option at the top of the configuration, and then in the "Select the format for the new column" box, find your desired date format (dd/MM/yyyy)

 

When you run this, it will output a new column with the desired format of the date from your user input.

 

Spoiler
customdate.PNG

 

I've attached a sample app, let me know if you have any troubles with it or any questions.

Labels