Adding days

[MaPerez]

Greetings,

I have the same problem. I want to create a new column where I add a day if the products change. For example

I need this

I was using the multi-row formula with datetimeadd(max_Date,1,"days") but I don't get the correct result. 

Thanks for your help!!

[MarqueeCrew · Accepted solution]

@MaPerez,

Here's a quick picture of the configuration that you're looking for:

Notice that there is a GROUP configuration by PRODUCT!

IIF([Product]!=[Row-1:Product],DateTimeAdd([Max_Date],1,"Days"),DateTimeAdd([Row-1:New_Date],1,"Days"))

If the product on the row isn't the same as the product above it, then add 1 day to the Max_Date.  Otherwise add one date to the prior result.

Cheers,

Mark

[Kenda · Accepted solution]

Hey @MaPerez!

To solve this, I first created an ID field using a Multi-Row Formula Tool and grouping by Product.

I then added a second Multi-Row Formula tool to check if the ID is 1 - if so, add one day to the max date, otherwise add one day to the new date in the row above. Also group by product here.

Hope this helps!

[MaPerez]

Thank you so much for your help!!!! I'm quite new with Alteryx :D

[MaPerez]

Thank you so much for your help!!!!!