Use alteryx to find data discrepancy

[187]

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	NAME	SCORE	DEPT
1	john	22	water
2	buff	33	water
3	silver	44	water
4	dickson	55	water

TAR

RECORD	STUDENT NAME	SCORE	DEPT
1	john	33	water
2	buff	33	water
3	silver	44	water
4	dickson	55	water
5	alex	66	water

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

ID	RECORD	Y
NAME	STUDENT NAME	N
SCORE	SCORE	N
DEPT	DEPT	N

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? 

[FilipR]

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

[binuacs]

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

[187]

@binuacs 

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.