Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Report discrepancies in data flow between multiple systems

  Hi All, I need help in reporting discrepancies in the data that is between different systems. So, for example, I have a source system (Table A) which has information as follows. Name Id ...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

Anonymous it can be super easy if you clarify the following points:

 

- ID column is unique in all these 3 Tables?

- what are we checking for incorrect/mismatch, email only?

- Are we comparing the value of only Table C with Table A and Table B? What happens if there is a mismatch between Table A & Table B or that will never happen? If there will be never a mismatch between Table A & Table B, it means we can compare Table C with any one of Table A & Table B.

 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi parry2k ,

 

Here are the answers to your questions:

1. Yes ID column is unique in all 3 tables.

2. Nope, mismatch could be in any of the fields email, course, name ect.

3. There is a mismatch between Table A and Table B in this case. 

 

I basically want to report anything that has a mismatch when data flows between the three tables. It would be great if the able numbers are scaleable.

 

Hope that answers your question.

 

Kind Regards,

Chris