Gelöst! Gehe zu Lösung.
@binuacs -- thank you for the prompt response. I appreciate it.
Once I downloaded the version and placed the source file into the subfolder AND then ran it, I only generate a single-record output. See attached.
What am I missing?
@TomBock the RecordID field should be selected in the cross tab tool, can you check?
@binuacs -- that did the trick. It wasn't checked... but now it's outputting the data as expected. Many thanks!!
Cheers,
Tom
@binuacs -- sorry, one more follow up question.
In "re-review" of your solution, could you please provide some info as to what exactly the logic for the Find/Replace tool is. I would I never thought to us it in this case. Just trying to learn from this challenge. Thank you.
@TomBock Find and Replace tool works very similarly to Excel Vlookup function. In your use case, the Name field will be looking against your look-up file and if find a match in the BEFORE field then the Name field will get replaced with the AFTER field in the lookup table
@binuacs -- great -- your explanation helps out a great deal. Again, thank you for the assistance w/ solving the challenge most efficiently.
Cheers,
Tom