Create variables based on 2 columns

[Kza40381]

Hi,  I am very novice with Alteryx and have been trying for hours to figure this out.  I need to create a variable that if Actual date is null then Current Planned Date for each item in the name column.  I created a column for the if statement for the date, however, I can not figure out how to do it for each name.  I have also tried transposing. 

Can someone please help me.  I have attached a screenshot of original data and outcome desired.

[AZuc]

@Kza40381 

could you provide the input dataset?

[Kza40381]

I just did.  🙂  thank you!

[Christina_H · Accepted solution]

Are you trying to calculate the Act vs Planned column?  If so, I think this is the formula you need:

if IsNull([Actual Date]) then [Current Planned Date] else [Actual Date] endif

Then you can use a cross-tab tool to get the pivot table:

[Kza40381 · Accepted solution]

Thank you so much Christina!  I tried for hours and so many different ways.  

[Christina_H]

No problem, glad I could help!

[Kza40381 · Accepted solution]

Thank you Christina!