Question: Is comparing fields (SQL: VAL1 = VAL2, VAL1 > VAL2 etc.) across Data Extensions supported in DESelect?
Answer: Yes, comparing fields across Data Extensions is supported in:
- Custom Values
- Subqueries (In Results/Not In Results filters)
How to compare fields?
To compare the value of a field with a field of the same or another Data Extension, click on the icon to switch to comparing with fields. Dropdowns appear with the available Data Extensions and fields you can compare with. Click on the icon to switch back to filter based on the value you enter.
When comparing the values of fields, the same operators are available as to when comparing with values entered by the user.
Read more about this functionality here.
- You would like to select contacts with a phone number that is equal to the mobile phone number.
- You want to get the order lines where the sales price is higher than the list price.