I have a question that is puzzling me for too long which is probably very easy to fix, so it would be very appreciated if someone could help me out.
I have two table charts from two different sources. One contains users with email addresses and one contains only email addresses, lets say:
1. Users
User UserEmail
Peter peter @blabla.com David david@blabla.com
2. Email CheckEmail peter@blabla.com
So bascally I want to indicate in the table(s) which email address match between the two tables. So to test I have created a new dimension in the "2. Email" table chart and entered: =if(CheckEmail=([UserEmail]),'Yes','No' ) This somewhat works but what appears to be happening is that all addresses in the table get a "No" and additionally a "Yes" reccord is written when the address is found in the "1. Users" table, so often two records per email address.
Is there an easy solution to just get the addresses once in the table indicating "Yes" / "No" or the other way around?
The important thing here is to understand how are you linking the 2 sources in your model because your "if statement" is performed using the related records.
Perhaps a quick way for you to verify is to create a simple model where you use the email address as key. For example:
Users: Load User, UserEmail, UserEmail as %Key from [your table 1];
Email: Load CheckEmail, CheckEmail as %Key from [your table 2];
