SOLVED
How to replace null value with previous row data
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Saravanan13
8 - Asteroid
‎08-01-2024
07:09 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello all,
I am looking to duplicate the values in previous row whenever there is a null value. Can anyone assist. I know we can use multi row field formula but not getting the desired output.
Input
accounts | Parent |
1225 | 232323232 |
5454 | |
545444 | |
242323 | |
43333 | |
334343 | 5454545454 |
3433 | |
343334 | |
5454554 | |
343333 | 4545454545 |
322222 | |
423211 | |
2431312 | 6767676767 |
344343 | |
4544544 | |
433433 |
Output-
accounts | Parent |
1225 | 232323232 |
5454 | 232323232 |
545444 | 232323232 |
242323 | 232323232 |
43333 | 232323232 |
334343 | 5454545454 |
3433 | 5454545454 |
343334 | 5454545454 |
5454554 | 5454545454 |
343333 | 4545454545 |
322222 | 4545454545 |
423211 | 4545454545 |
2431312 | 6767676767 |
344343 | 6767676767 |
4544544 | 6767676767 |
433433 | 6767676767 |
Solved! Go to Solution.
Labels:
- Labels:
- Datasets
2 REPLIES 2
MilindG
12 - Quasar
‎08-01-2024
07:53 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Saravanan13 Does this work for you?
CoG
14 - Magnetar
‎08-01-2024
07:55 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
![](/skins/images/6056C79A596CAB15526D64C598622101/responsive_peak/images/icon_anonymous_message.png)