Upload previous day's data in today's workflow

[Kaish]

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.   

[aatalai]

@Kaish you can use the dynamic rename tool selecting name = the date in the relvant name and replace it with "Current data"

Let me know if you would like a more detailed breakdown 

[Kaish]

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

[aatalai]

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_])

[dreldrel]

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