Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

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

2 REPLIES 2
JessieC
Alteryx
Alteryx
ranjit_kumar
5 - Atom

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.

Labels