Data analysis question

[Detriotlions]

We have prod data for quarter for 9005 rows. And legacy report for that quarter has 9930 rows 
How do some one work on them to get  both of them same ??

[Detriotlions]

The prod data is from prod db 

 They made the adjustment ment to legacy report

[Batman_fan]

since when people stopped using common sense in job?

[chicchara]

first check individual ga emaina duplicates unaaye emo in each file..(im expecting dups in legacy)

group by chey ..easier way to find duplicates.

if duplicates present..then get clarity on how to select latest record.

after getting info on which record to select...then join prod db and legacy

and see how many matches you are getting

matched records lo dups unaya check chey..report if them if present

one-one match dorkina vaatini side ki pettu..

match dorkani vaatini side ki pettu.

report them 

 

 

[Detriotlions]

23 minutes ago, chicchara said:

first check individual ga emaina duplicates unaaye emo in each file..(im expecting dups in legacy)

group by chey ..easier way to find duplicates.

if duplicates present..then get clarity on how to select latest record.

after getting info on which record to select...then join prod db and legacy

and see how many matches you are getting

matched records lo dups unaya check chey..report if them if present

one-one match dorkina vaatini side ki pettu..

match dorkani vaatini side ki pettu.

report them 

 

 

 i met one dq person who worked on that for 200 hrs in onw week to know the difference 

no practical use ani chepadu 

if something brokes in prod will fix it now prob ani annadu 

he is FTE in company past 10 years 

w

[boeing747]

why dont u do a vlookup on the data to see which rows are not matching or redundant in-between these 2 datasets?

[chicchara]

12 minutes ago, Detriotlions said:

 i met one dq person who worked on that for 200 hrs in onw week to know the difference 

no practical use ani chepadu 

if something brokes in prod will fix it now prob ani annadu 

he is FTE in company past 10 years 

w

2 datasets lo diff teliyadaniki 200 hrs antey.. salute sir

[Bhai]

[kasi]

1 hour ago, Batman_fan said:

since when people stopped using common sense in job?

[chamcha420]

1 hour ago, boeing747 said:

why dont u do a vlookup on the data to see which rows are not matching or redundant in-between these 2 datasets?

[Pitta]

1 hour ago, Bhai said:

[Bhai]

1 hour ago, Pitta said:

SELECT pg_is_in_recovery()

[Pitta]

Just now, Bhai said:

SELECT pg_is_in_recovery()

[Bhai]

Just now, Pitta said:

You selected the All Industries database for 7/2017 - 6/2018.

[Renault]

3 hours ago, Detriotlions said:

We have prod data for quarter for 9005 rows. And legacy report for that quarter has 9930 rows 
How do some one work on them to get  both of them same ??

Delete extra rows