Find and Replace tool not returning correct value
- 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
I am trying to append fields from cross reference file to data in my workflow and the Find and Replace tool is returning the incorrect value. My cross ref table contains multiple records of the same type but it is sorted so the most recent entry (the one I'm looking for) is the first value:
I am getting "Moisture Farmer" where I want "Force ghost". Does the Find and Replace tool search from bottom to top? How exactly is it finding the data?
I have the "Entire Field" radio button selected and "Case Insensitive Find" checked.
Solved! Go to Solution.
- Labels:
- Help
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
If you have duplicate lookup values it is best to run it through a unique tool first. I believe that find and replace goes bottom to top, but you can avoid having to worry about that with a sort and unique to ensure that you are mapping with the values that you expect.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I never had a duplicated Key value in the R input, It appears to check every-row in the R for a match from top to bottom
Either, use the Summarize tool, and group by Name, and First by Occupation, before you run it against the Find a replace.
Or Sort the R Input by Descending Record ID
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks, @BrandonB
I'll experiment with a combination of the Sort and Unique tools and see how that goes. Appreciate the answer!!
