community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Comparision of data between two different tables in different databases.

ranjit_kumar
5 - Atom
‎11-01-2019 07:52 AM

Could anyone help me to design how can I compare data between two tables in different databases - one is DB2 and another one is SQL SERVER. I need to compare the data between 15 columns between both the tables in both the DB's and find out the mismatches of each record column wise. Could anyone help me to design the work flow and how to configure the each stage in the design as I'm beginner in Alteryx

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
JessieC
Alteryx
Alteryx
‎11-01-2019 11:39 AM

Hi @ranjit_kumar ,

 

Here is an example from another user - https://community.alteryx.com/t5/Alteryx-Use-Cases/Data-Check-Between-Two-Sources/ta-p/270082

 

Hope this helps!

Reply
0 Likes
ranjit_kumar
5 - Atom
‎11-05-2019 03:17 AM

Thank you Jessie! Looks like its a complex design any simple workflow to compare two different db tables data that contain almost 36 columns each.

Reply
0 Likes
Community Live Fifa Workshop
Labels
Top Solution Authors
View All