Merging multiple documents into one, but need some type of vlookup functionality for final
- 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
So I've been scouring the boards trying to find the one solution that works for me...I know I'm close...
I've used joins and unions and just can't seem to get it right. I am merging two documents with a 'Patron Code' and a 'Customer Name' tied together in two seperate columns. Once I have those two columns apended to each other, I need to look against a third document and if a patron code from the previous merged document IS there, I want that to come out on the report with ALL the data that is on the third document. Any suggestion would be helpful
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @dberroth ,
If I understood your problem right, you can solve it by adding a join tool after your union tool using the patron code as a key field. Would that work for you? If not, please share a bit more detail about your problem, please.
Best,
Fernando Vizcaino
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you! I knew I was close, had a few things twisted around. Appreciate your help!
![](/skins/images/A7612391DEAF4EF69C140133EA533832/responsive_peak/images/icon_anonymous_message.png)