What's new in Customer Journeys?

Connect and learn more! ×
OTBI Filter for Numeric using MAX — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OTBI Filter for Numeric using MAX

Received Response
162
Views
1
Comments

Summary:

Thinking of the approach how to apply Filter in OTBI to get the Max value of column where column is only numbers.

Content (required):

Data on DFF column is Varchar and goal is to get the max value while and ignoring the alphanumeric value records.

Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

thinking of using regexp_like in filter condition to but not sure if correct syntax or approach.

EVALUATE('REGEXP_LIKE("Job"."PER_JOBS_DFF_DB", ''^[[:digit:]]+$'')')

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!