Use alteryx to find data discrepancy

Question

Hi there,

Just wondering if alteryx tool can be implemented to find data discrepancy between two data set with detailed info or setting background color

Suppose we have two data set 
SRC

ID NAMESCOREDEPT1john22water2buff33water3silver44water4dickson55water

TAR

RECORDSTUDENT NAMESCOREDEPT1john33water2buff33water3silver44water4dickson55water5alex66water

and i have one mapping info like this  Y stands for primary key that can find unique data

IDRECORD YNAMESTUDENT NAMENSCORESCORENDEPTDEPTN

I want the result like either set the background color for the difference or give the cell information like C2 , R6 has difference.

Any thoughts?

187 · Answer

@binu_acs

yup i know join tool can do this, but the critical difficulty is the column name is dynamic read from my mapping file and it might change, cause we need to provide this for a common solution.

binu_acs · Answer

@187 One way to apply difference to all records with differences

Differences_Formatting.yxmd

FilipR · Answer

You can use the Join tool for that. Whatever is not in both sets, will be in the R and L outputs.

join.yxmd