Alternative to Multiple Multi Row Formula Tool to Pick above Row Values if null
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
harshal98
8 - Asteroid
‎01-16-2021
06:24 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Have to fill in empty values basically null values with the values above group by id.
But there are many columns so have to go with multiple Multi Row Tools...What is the Alternative that i can do it for all columns at once?
Input
Output
Labels:
1 REPLY 1
AngelosPachis
16 - Nebula
‎01-16-2021
07:23 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @harshal98 ,
Try using a transpose tool before the multi-row formula tool to pivot all fields that you want to fill in values with the multi-row formula tool.
Then, make sure you configure the multi-row formula tool as shown below:
That will restart the calculation for each id and Name field, assuring your tool works properly.
Hope that helps, let me know if that worked for you.
Regards,
Angelos
