How do I figure out the mismatch of the number in field ?

[Kinetic_analytics]

Hello:

I have two separate report. Where the ID is similar, How do I differentiate match and mismatch of EI Number?

Thanks

[Luke_C · Accepted solution]

Hi @Kinetic_analytics 

You would join the two data sets on the ID, then can filter to see if the EINs are the same. in the below, the F anchor shows the 2 instances where they don't match.

I suggest checking out the interactive lessons to learn more about the basic functionality of these tools.

[Kinetic_analytics]

Thank you for helping me in my learning process.