UpperLower Function

image_pdfimage_print

The UpperLower function checks or changes an input field.

Parameters

Case

Possible values:

  • UPPER: text is changed into uppercase letters.
  • LOWER: text is changed into lowercase letters.
  • FIRSTCASE: returns the first value in preceding rows that is case-insensitively equal to the input value.

Verifycase

Possible values: true/false. If true, checks whether in preceding rows a value has occurred that is case-insensitively equal to the input value. In that case, a warning is raised. The option has no influence on the result of the function.
Example

The option FIRSTCASE is particular useful to assure data quality in cube loads with drillthrough scenarios. The result of the function depends in this case on the order of the rows.

image_pdfimage_print
Was this post helpful?
NoYes (No Ratings Yet)
Loading...