Alteryx Designer Cloud Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Cloud.
SOLVED

How can I turn a timestamp (int) column into a datetime column?

TrifactaUsers
10 - Fireball

I am ending up with timestamp (int) columns after doing min/max functions on dates during a pivot. I am unsure how to turn them back into datetimes within Cloud Dataprep.

10 REPLIES 10
Trifacta_Alumni
Alteryx Alumni (Retired)

As of 2020, new functions have been released that produce dates as the output of aggregations (instead of unixtime values). You can read more about the functions here: https://community.trifacta.com/s/article/Aggregating-date-time-columns

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!