Join our Community in its new Home - The Datorama Trailblazer Community Group!
It's been an amazing 3 years coming together in this forum to collaborate, innovate, support, and inspire each other about our shared usage of Datorama. While this is not quite a goodbye, we are excited to announce that we are getting a fresh start in our new home within the Salesforce Trailblazer Community. We have a ton of fun new content planned and you may even see the revival of some of our most popular posts from the past few years.
We’ll be keeping this group around for a bit for you to peruse, but as of November 15, we will no longer be allowing new posts or comments. Be sure to join our new group at https://www.salesforce.com/success-datorama to keep the conversation going.
We can’t wait to see you there!
It's been an amazing 3 years coming together in this forum to collaborate, innovate, support, and inspire each other about our shared usage of Datorama. While this is not quite a goodbye, we are excited to announce that we are getting a fresh start in our new home within the Salesforce Trailblazer Community. We have a ton of fun new content planned and you may even see the revival of some of our most popular posts from the past few years.
We’ll be keeping this group around for a bit for you to peruse, but as of November 15, we will no longer be allowing new posts or comments. Be sure to join our new group at https://www.salesforce.com/success-datorama to keep the conversation going.
We can’t wait to see you there!
Platform Advanced Exam - Data Load Rules
Tom_Brennan
LondonACCOUNT_ADMIN 
in Help Center
Hi there,
I'm currently working through the advanced exam and getting stuck on part of Section 1 Task 3 where it asks us to 'Exclude rows where Site Name contains ‘Facebook’ or ‘Twitter’ using Data Load Rules.'
I have created Data Load rules in a number of different ways to try and exclude these, but none of them seem to be working. My thoughts were that the below should meet the criteria to exclude the correct rows:
Match Action: Include Rows
Filters
Site Name - Not Contains - Facebook
OR
Site Name - Not Contains - Twitter
So this should only include rows that don't contain Facebook or Twitter in the Site Name.
I've tried other variations including using 'Not Equals' rather than Not Contains however it doesn't seem to exclude the rows.
Can anyone help or point me in the right direction with this?
Thanks
Tom
I'm currently working through the advanced exam and getting stuck on part of Section 1 Task 3 where it asks us to 'Exclude rows where Site Name contains ‘Facebook’ or ‘Twitter’ using Data Load Rules.'
I have created Data Load rules in a number of different ways to try and exclude these, but none of them seem to be working. My thoughts were that the below should meet the criteria to exclude the correct rows:
Match Action: Include Rows
Filters
Site Name - Not Contains - Facebook
OR
Site Name - Not Contains - Twitter
So this should only include rows that don't contain Facebook or Twitter in the Site Name.
I've tried other variations including using 'Not Equals' rather than Not Contains however it doesn't seem to exclude the rows.
Can anyone help or point me in the right direction with this?
Thanks
Tom
Tagged:
Best Answer
-
jharris
LondonSYS_ADMIN 
Hi @Tom_Brennan,
The logic of negative matching can be a little tricky to get your head around.
Think of it this way: if you have a row where the site name is "Facebook", then it meets your condition of not being "Twitter". On the other hand, "Twitter" rows are not "Facebook"!
The solution here is to use the AND operator, not OR. In that case, only rows where the site name is not "Facebook" AND not "Twitter" will be included.
Thanks,
Josh
Answers
Thanks so much for your explanation - it makes sense when explained in that way. Really appreciate you taking the time to answer.
Thanks again
Tom