Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Take a date from user input and pass on to downstream flows

yoyoumysin
6 - Meteoroid

Trying to get a user input of a date and then feed into a formula tool to append a new column and populate each row with this date as entry into the newly appended column.

 

I ran into a lot of trouble in:

1. Figuring out how to configure the user interface tool, and,

2. Converting between strings and dates.

 

Input

TaskName
1ABC
2XYZ

 

Then ask for user to choose/enter date: 5/15/2021

 

Output would append a column called "Date" and each field shows 5/15/2021.

 

TaskNameDate
1ABC5/15/2021
2XYZ5/15/2021

 

1 REPLY 1
phottovy
13 - Pulsar
13 - Pulsar

@yoyoumysin 

 

Would the user enter a date for each task or will they just enter one date? Attached is a workflow using the Date interface tool that shows you two ways to accomplish this if the date is always the same.

Labels