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