Solved! Go to Solution.
Hi Jenna!
You can apply a New formula [derive] and use the NOW( ) function (https://docs.trifacta.com/display/PE/NOW+Function) or the TODAY( ) function (https://docs.trifacta.com/display/PE/TODAY+Function). This will return a new column with the result of the function you chose at the moment the job is triggered by the schedule.
The difference between the two is that:
Both functions accept an optional timezone parameter to specify the region of interest. You can see a full list of the supported timezones here (https://docs.trifacta.com/display/PE/Supported+Time+Zone+Values).
Awesome. I saw those functions but wasn't sure if their results would update every time the job ran. Glad to know that is the behavior.