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
ryan_mayu's avatar
ryan_mayu
Super User
6 years ago

Anonymous 

 

My solution can't 100% meet your request.

 

Use lookup value to get email and course value from TA and TB

email from TB = LOOKUPVALUE('TB'[Email],TB[Name],TC[Name])

 

Then compare if TC = TB and TC = TA

iscorrect = if(TC[Email]=TC[email from TA]&&TC[Email]=TC[email from TB]&&TC[Course]=TC[course from TA]&&TC[Course]=TC[course from TB],"Correct", "Wrong")

 

Then create a pie chart.

Legend: iscorrect

Details: name

Values: count of iscorrect

 

Hope this is helpful.

 

 

 

 

parry2k's avatar
parry2k
Super 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