DESelect November ’19 Release: Comparing fields

DESelect November ’19 Release: Comparing fields using drag and drop in Salesforce Marketing Cloud

This month the DESelect product team is proud to release functionality to support selections that filter by comparing fields from the same or related data extensions. For example, getting the order lines where products were sold for less than the product list price.

 

Available for: DESelect Enable, DESelect Plus, DESelect Advanced.

Use case

Imagine having 2 data extensions: Products and Order Lines. In Products we find product details like the name, product family and the list price (the price for which the product normally sells). In Order Lines, we can see the quantity, product and the actual sales price.

We’ll start by selecting the Products and Order Lines data extensions, and set the relation to Order Lines with matching Products.

Next, we’ll add in a filter for Sales Price. With the new blue button, you can switch between filtering on a fixed value and comparing with data extension fields.

After hitting the switch button, 2 dropdowns appear. In the first one you select the data extension you want to compare against. The second one is the field of the selected data extension you want to use.

In this case, we’ll select the Products data extension and the List Price field. Our entire filter looks like this:

When we run the query, we’ll get all the order lines where a product was sold for less than the list price.

Other use cases

Here are some examples of other queries you may want to build that would involve comparing with other fields:

  • Selecting contacts with an email address from a domain different from the company’s website domain
  • Selecting contacts with the phone number equal to the mobile phone number
  • Referring to a field from the main query when using sub queries.

Conclusion

There are many valuable use cases where you’d want to filter by comparing to a field of the same or another data extension. DESelect now makes it very easy to do so, as you can easily select the related data extensions and the available fields from a dropdown. Fields you cannot compare against are automatically excluded from this list.

Get in touch if you want to try this great functionality for yourself and see how much time DESelect can save you.

  • What’s new in DESelect: June 2022

    Summer is finally here along with powerful new features from our team. Happy June! It’s Garrett again with big product updates for you as we start the summer. DESelect proudly opened the door to non-technical marketers by ending the technical dependencies around SQL. We also take pride in equipping technical marketers with tools that increase […]
  • What’s new in DESelect: April 2022

    Get more time back in your day with DESelect. That’s not an April Fools’ joke! Welcome to April! It’s Garrett, from DESelect, here to share this month’s Product updates. It’s no secret that our no-code products already help thousands of marketers unlock the full power of SQL for more effective marketing campaigns. Today we’re excited […]
  • DESelect February ’22 Release: Scheduling of waterfall selections and moving around selected data extensions

    It is the first release of the year so let’s make it interesting! As you may already know, DESelect loves to bring customer’s ideas to life. And so, we are introducing 2 new powerful functionalities that come by popular demand: scheduling of waterfall selections and moving around selected data extensions.   Let’s get started! Scheduling […]
  • DESelect Dec ’21 Release: Folders for available data extensions, selection templates and descriptions, and improved date filters

    It’s that cold snowflakes season and DESelect is introducing some new cool features: folders for Available Data Extensions, selection templates, and descriptions, and improved date filters. Let’s dive in! Folders for Available Data Extensions Available for: DESelect Segment Enable, DESelect Segment Plus, DESelect Segment Advanced Being able to search for the data extensions that you […]

Stay Connected

Join our newsletter to receive updates and helpful SFMC guides

Subscribe to the Newsletter
Receive Salesforce Marketing Cloud tips and
tricks and DESelect updates

By clicking the “Subscribe now” button, you agree to the DESelect Terms of Use and Privacy Policy.