This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
What I did next to make the Multi-Row expression a little simpler is sort by OrderID and Date so that any item that has a date is on top. I then used the multi-row formula building block to replace any Null dates with dates, only if there is a date in that OrderID:
I've attached the workflow to this post.. Hope this helps!
I hope i'm understanding your question correctly. But to open the packaged workflow I attached, open it from Alteryx Designer and select 'Import' and then 'Yes'. I've also attached it as a .yxmd
The Multi-Row Formula will allow you to do a calculation against multiple rows so [Row-1:data_field] means look at the previous row (-1) and use that value in the current row (+0). When you use this with your own data, use the variables section in the configuration window to select the data field you want to work with:
And make sure you 'Group By' the OrderID to make sure it works correctly!
If this solution worked, make sure you mark it as a solution!