Upload previous day's data in today's workflow

Question

Hi All, I am stuck in a problem where I have a data which is today's data, there is a column named current data, I want that data to be in my workflow which is simple, now comes the tricky part where I want a new column which has a previous data, in this column I want to update data of yesterdays "current data". I have only one input file for today, I can't have 2 inputs, so this becomes difficult for me to distinguish between today and yesterday, can someone please explain the solution.

dreldrel · Answer

You could just use a formula tool with DateTimeAdd. For example, DateTimeAdd(DateTimeToday(),-1,'day') to get your desired result. If this helps, feel free to like the comment and select as a solution

aatalai · Answer

sure @Kaish take a look at this work flow

here is the formula

IIF( [_CurrentField_]= DateTimeFormat(datetimeadd(datetimestart(),-1,"day"),"%Y-%m-%d"),"Current data",[_CurrentField_])

Upload previous day's data in today's workflow.yxmd

Kaish · Answer

Hi @aatalai , thanks for the reply, I am new to Alteryx, can you please share the detailed breakdown