Data Check

Adarsh_R3

Hi everyone happy new year!

I have two data files which I need to compare the values of the column "Name". Is it possible to get output using a tool that compares the values of the column and says which values are missing from the data (Raw Data) w.r.t  Check file? 

Thanks in advance and please let me know if you need any more details. 

Data Check.yxmd

DawnDuong

hi @Adarsh_R3 

I only saw a data input file - not sure if it is because my version is lower than yours.

In principle, the use case you describe is possible with the Join Tool, which gives 3 outputs:

- L: those that only exist in Left inputs

- J: those that exist in both Left and Right inputs

- R: those that exist in Right inputs only.

If you want to check with data is missing from the Raw data wrt to the "check file", then:

- Connect Raw File to L

- Connect Check File to R

- Select the Join settings based on the criteria that you need to check.

The data that is missing from the Raw File = those that exist in R but not in L >>> they are shown in your R output.

If you are not familiar with the Join Tool already, you may find these two interactive lessons helpful: 

https://community.alteryx.com/t5/Interactive-Lessons/Joining-Data/ta-p/76634

https://community.alteryx.com/t5/Interactive-Lessons/VLookUps-with-Designer/ta-p/80201

Dawn.