Import worksheets (different schema) and sync/rename columns
- 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
 
 
Solved! Go to Solution.
- Labels:
- Dynamic Processing
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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?
 
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@TomBock the RecordID field should be selected in the cross tab tool, can you check?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@binuacs -- that did the trick. It wasn't checked... but now it's outputting the data as expected. Many thanks!!
Cheers,
Tom
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@binuacs -- great -- your explanation helps out a great deal. Again, thank you for the assistance w/ solving the challenge most efficiently.
Cheers,
Tom
