SOLVED
Replacing Null Fields
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
anthony_wright
6 - Meteoroid
‎04-22-2015
10:07 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Need to replace Null values with value in first row.
(i.e. DIV field would test the row for If "IGS," then DIV 2 = "IGS" until it came across another value where DIV field if "ECS," then DIV 23 = "ECS."
What's the best way to approach this data preparation exercise?
Solved! Go to Solution.
Labels:
- Labels:
- Preparation
4 REPLIES 4
Ned
Alteryx Alumni (Retired)
‎04-22-2015
10:22 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This is exactly what the MultiRowFormula tool is for. The formula you need is:
if IsNull([DIV]) then [Row-1:DIV] else [DIV] endif
davidhenington
10 - Fireball
‎12-08-2016
10:41 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
what about using the last non-null value instead of the first?
davidhenington
10 - Fireball
‎12-08-2016
10:49 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
haha, apologies, i see that's exactly what this does. Excellent, love you Alteryx!
cdaragan
5 - Atom
‎02-07-2018
06:00 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Could you pls help me replacing null values with 'Unknown' in a table
