Alteryx Designer Desktop Discussions

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

Creating a new Column with Time

briantrg
5 - Atom

Hi, 

 

I was just wondering how I could create a new column with a time value, with the values starting at 00:00 for each row in the column.

 

Thanks

2 REPLIES 2
kat
12 - Quasar

Hi @briantrg

 

Do you just want all rows to show 00:00? Then you can use a formula tool, set it to time and type this in. The format is HH:MM:SS

time.PNG

If you want the time to change with each row you'll need something like the multi row formula tool with datetimeadd formula.

 

Cheers

Kat

 

 

briantrg
5 - Atom

Thanks a lot Kat! 

Labels