How to match data from 2 differents databses ?

I have one database with a view who contains a list of names. I need to see if those names are présents in the Address book (names.nsf) and view which ones is not matching.
Do you have a little code who do that ?
Thanks a lot for your help.
Dan
Dan LapAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

 
TobyJHCommented:
Yes, you can use an agent that matches and then adds a True flag.
0
 
Dan LapCommented:
Thanks TobyJH, do you have some piece of code for me ? I'm not a developer and I need a solution for my client.
Thank you very much !
Best regards..
0
 
Sjef BosmanGroupware ConsultantCommented:
Do you have the software to do the development, i.e. Domino Designer? If not, either get it and install it or ask someone in your organization to develop it for you.

The next best solution is to export the the data to Excel, from both databases, and use that to compare the names.
1

Experts Exchange Solution brought to you by ConnectWise

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
 
Matt NicholasBusiness AnalystCommented:
No code required for this one (piece of cake to learn also)

Download the free Power Query add-in for MS Excel 2016
Connect to both datasets/databases using the 'Get andTransform' function in Power Query
Merge both datasets, using the 'names' column
Add a conditional column to identify the differences easily

You will have a simple and dynamic way to do this in future by simply pressing 'refresh'.

Give it a go, you won't regret it! No code means more simplicity!
0
 
Matt NicholasBusiness AnalystCommented:
No response from poster, closing job
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.