Data Cleansing for dynamic field inputs
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
nathanedwards
5 - Atom
‎09-20-2024
09:57 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I know the normal "Data Cleansing" tool has limitations where you have to make sure to reselect all fields when your input has dynamic field names.
What is the formula to use in the "Multi-Field Formula" tool to mimic the "Replace Nulls" section of the "Data Cleansing" tool?
Labels:
- Labels:
- Workflow
2 REPLIES 2
binuacs
21 - Polaris
‎09-20-2024
10:31 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@nathanedwards you can write to the formula like below
apathetichell
19 - Altair
‎09-20-2024
10:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@nathanedwards - you should use @binuacs suggestion. Data Cleansing is a bad tool when used at scale. It's a memory eater which can be hugely problematic in certain situations. Multi-Field Formula is dope.
