Compare same data sitting in 2 different data sources

[jalaomar]

Hi all,

I am wondering if there is a simple way to compare same data that is sitting in 2 different data sources?

I have financial related information for a list of projects (many projects) and i would to compare data source 2 with data source 1.

Data source 1 have reliable data

Data source 2 is not so reliable hence I would to compare to data sorce 1. Please see screenshot 

[v-janeyg-msft]

Hi, @jalaomar 

There is no way to directly compare data sources, you must compare each column. Can you upload some insensitive data samples and expected output? So we can think of a workaround for you.

Best Regards,
Community Support Team _ Janey