In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!
community Alteryx IO MyAlteryx
alteryx Community
Search
This Board
  • Global Community
  • This Category
  • This Board
  • Knowledge
  • Users
 cancel
Turn on suggestions
Showing results for 
Search instead for 
Did you mean: 
Close
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
view community events
Labels
Top Solution Authors
View All