Does anyone know whether or not the rules you put in the over ride data types area are applied sequentially like they would be in a SQL case statement (i.e. once a field evaluates to TRUE it ignores the subsequent logic)?
Solved
Are "Over Ride Data Types" applied in order like a SQL case statement?
Best answer by Christian Hauggaard
Hi Brandon
Apologies for the late response. Yes, the rule at the top of the list of rules overrules subsequent rules. For example, if we transform the AverageRate field below from numeric to text, and then add a subsequent rule (further down the list) to convert it to a decimal, the result will be a text field. In other words the first rule to evaluate to TRUE (going down the list from top to bottom) will apply, and any rules further down the list that also evaluate to TRUE will be ignored. You can use the “Move Up” and “Move Down” buttons on the top right to rearrange the rules.
+5Hi Brandon
Apologies for the late response. Yes, the rule at the top of the list of rules overrules subsequent rules. For example, if we transform the AverageRate field below from numeric to text, and then add a subsequent rule (further down the list) to convert it to a decimal, the result will be a text field. In other words the first rule to evaluate to TRUE (going down the list from top to bottom) will apply, and any rules further down the list that also evaluate to TRUE will be ignored. You can use the “Move Up” and “Move Down” buttons on the top right to rearrange the rules.
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
