Hi,
I need to compare two data columns in two different columns and see which one does not exist, e.g
.
Table1: Emails
Table2: Emails
I would like to display and compare Table2 Email column which does not exist in Table1 Email column and display mismatch emails? How do I achieve this?
A way to accomplish what you are looking to do is create a column in your ‘Table1 Email’ that evaluates whether the email exists in ‘Table2 Email’ (ie. the evaluation will results in TRUE/FALSE). From there in app builder, you can create a List that displays only emails where the evaluation is FALSE.
Here is an example I created in my account:
Email1 Table:
Email2 Table:
In Email1 Table I created a formula to check if the email exists in Email2 table:
After my table is set, I can go into App Builder and create a list that filters for emails that evaluated to FALSE: