Find/Replace or Dynamic Replace: only certain columns AND only certain values
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I'm wondering if the community can help me figure out this particular use case: I have many fields in a data table that I'd like to elegantly complete a find/replace on.
At one point data was being written into the table with an ID that served as a lookup (1="Low", 2="Medium", 3="High") and then at a later point the low/med/high values were written directly to the table (in my case I have ~20 fields where I'd like to do a F/R on about 100 ids but leave any non-match text in place. yay!)
Here's an example:
Field_foo | field_bar | noreplace |
1 | 2 | Sarah |
Low | Medium | Jane |
2 | 1 | Molly |
3 | 3 | Cesar |
High | Low | Mary |
should turn into
Field_foo | field_bar | field_noreplace |
Low | Medium | Sarah |
Low | Medium | Jane |
Medium | Low | Molly |
High | High | Cesar |
High | Low | Mary |
I've gotten dynamic replace with dynamic field selection to work, but the kicker there is that it nulls all the values in Field_foo and Field_bar that don't match these numeric ids (ie. the ones I don't want to replace). I've gotten the Find/Replace tool to work, but I'd rather not have to use it 20 times or need to modify this flow if, say another 3 fields get added.
Any suggestions?
Solved! Go to Solution.
- Labels:
- Common Use Cases
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
With joins that may change in left my common approach is to tranpose the data. This may work in your instance! Then you will always be joining on a single field.
Ben
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Ben,
I hadn't thought of Transpose; what a great idea! With that, I got my flow to work.
Thanks!
