SOLVED
Impute string values
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
Tadhgo95
5 - Atom
‎11-23-2021
06:49 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
This should be incredibly easy but I'm struggling to find a workaround as the imputation tool only works for numeric values.
I'm just wondering how to replace the null value with "June" in my workflow. See screenshot below.
Any help appreciated.
Solved! Go to Solution.
Labels:
- Labels:
- Workflow
3 REPLIES 3
Alteryx
‎11-23-2021
07:31 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Tadhgo95
If it is consistent that every null value should become June in this case, a basic IF statement in a formula should resolve like so:
‎11-23-2021
07:59 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you
benjaminmartin16
6 - Meteoroid
‎11-09-2022
11:13 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
hello,
I am curious what if the string is not constant and you are trying to make an assumption that just replaces the undesireable value with the most frequently appearing value? is there like an if x then mode of y type of thing you can do with strings?
![](/skins/images/303A6AD65FCA043F1D2938424191616C/responsive_peak/images/icon_anonymous_message.png)