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
Icon for Super User rankSuper 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.

 

 

 

 

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
6 years ago

LOOKUPVALUE is a great approach. Another approach is to use TREATAS where you impose the parameters of the desired pattern onto the table to be tested, and the gaps will then be shown (or rather you will see stuff missing) as a result.