We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Fill Down...Diagonal

JMart2135
8 - Asteroid

Hello,

 

I have a table like the one below that I want to fill down but diagonally (From "New Value"  down 1 row, left 1 column to "Prev Value")- grouped by my task number. After this i will be filtering out the rows where Prev Value=New Value. I am using this as a change log for this date field. I know how to fill down normally, but not sure how to go about this diagonally. Any ideas, other methods are welcome.

 

 

TaskPrev ValueNew ValueLast Modified
0001 2/7/20203/11/2020 15:07
0001 WANT "2/7/2020" HERE3/7/20203/15/2020 15:07

 

Thank you!

 

Jesse

2 REPLIES 2
Maskell_Rascal
12 - Quasar

Hey @JMart2135 

 

You can accomplish this with the Multi-Row Formula tool. You even have the option to Group By specific fields, so it will limit the fill down within a grouping like say an account number. 

 

Anyways, here is how you'd set it up. 

Maskell_Rascal_0-1621546122325.png

 

I've also attached a sample workflow for you to try out. 

 

Thanks!

Phil

JMart2135
8 - Asteroid

Thanks @Maskell_Rascal ! I knew I was overthinking it. Definitely been a long week. Thanks again!

Labels