Comparing Values
Upcoming Classes
Online
Instructor-led online training
Location | Mar 2023 | Apr 2023 | May 2023 | Jun 2023 | Jul 2023 | Aug 2023 | Sep 2023 |
---|---|---|---|---|---|---|---|
AMER Brazil Time - Virtual (Portuguese) |
Apr 6 Apr 18 |
May 9 May 23 |
Jul 4 |
Aug 9 Aug 29 |
Sep 5 |
||
AMER Pacific Time - Virtual |
Apr 12 |
Jun 28 | |||||
APAC Sydney - Virtual |
Apr 13 |
May 23 | |||||
AMER Eastern Time - Virtual |
Apr 19 Apr 26 |
May 17 |
Jun 1 Jun 13 | ||||
APAC Singapore - Virtual |
Apr 25 |
Jun 6 |
Jul 25 |
Sep 5 |
|||
EMEA Greenwhich Mean Time - Virtual |
May 10 |
Jun 6 | |||||
AMER Eastern Time - Virtual (Spanish) |
May 16 | ||||||
Fast Lane Italia - Milano |
Jul 10 | ||||||
EMEA UK Time - Virtual |
Aug 30 |

Summary
This three-hour course is for power users who want to learn how to compare field values using eval functions and eval expressions. Topics will focus on using the comparison and conditional functions of the eval command, and using eval expressions with the fieldformat and where commands.
Objectives
Topic 1 – Using eval to Compare
- Understand the eval command
- Explain evaluation functions
- Identify and use comparison and conditional functions
- Use the fieldformat command to format field values
Topic 2 – Filtering with where
- Use the where command to filter results
- Use wildcards with the where command
- Filter fields with the information functions, isnull and isnotnull
Topic 3 – Using Fields in Searches
- Use fields correctly in basic searches
- Use fields with operators
- Use the rename command
- Use the fields command to improve search performance
Topic 4 – Comparing Temporary versus Persistent Fields
- Differentiate between temporary and persistent fields
- Create temporary fields with the eval command
- Extract temporary fields with the erex and rex commands
Topic 5 – Enriching Data
- Understand how fields from lookups, calculated fields, field aliases, and field extractions enrich data