Multi-Row Formula to "copy up" values?
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have a workflow that uses a multi-row formula to "copy down" values but I have a new data set that requires the values to "copy up". I've been playing around with the formula but can't quite get it to work.
Formula:
IIF(isnull([Field1]),[Row-1:Field1],[Field1])
Sample Data:
Field1 | Desired Output |
[null] | A |
[null] | A |
[null] | A |
A | A |
[null] | B |
[null] | B |
[null] | B |
B | B |
Solved! Go to Solution.
- Labels:
- Common Use Cases
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Easiest method is probably to assign a RecordID to each row, then Sort your data Descending, then use Multi-Row tool to fill down values, then re-Sort data Ascending to put it back in the right order... let us know if that does the trick!
Cheers,
NJ
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @ddiesel
I would use a record ID to sort so that you can fill down and then resort the data back to its original form.
Let me know if that helps!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Due to the way the Multi-Row tool works it still scans down the data but just reads one record ahead.
The best way I have found to do this is to use a RecordID column and to reverse the order of the dataset. Do the Multi Row imputing and then reverse.
Quick sample attached
(same as @NicoleJohnson and @TonyM solution)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Wow!!! Many thanks to you all for the fast reply! I was able to complete the analysis while still on the phone with the requester! Needless to say, they were very impressed! Thank you!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You don't know what you don't know until you need to know 🙂
Almost 18 months of using Alteryx, I didn't need a solution to this exact problem and I reached the same place as in the original question and was stumped. This did the trick, thank you guys. Now I know a bit more.
