Comparision of data between two different tables in different databases.

[ranjit_kumar]

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

[JessieC · Accepted solution]

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!

[ranjit_kumar]

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.