Profiling Getting Started Guide

10.5
- 10.5.9
- 10.5.8
- 10.5.7
- 10.5.6
- 10.5.4
- 10.5.2
- 10.5.1
- 10.4.0
- 10.2.2
- 10.2.1

Back Next

Task 1. Create Expression Rules and Run the Profile

In this task, you create two expression rules to parse the FullName column into two virtual columns named FirstName and LastName. The rule names are FirstName and LastName.

In the

Library

workspace, click the

Profile_LA_Customers

profile.

The profile results appear in summary view.

Click

Edit

The

Profile

wizard appears.

Click

Specify Rules and Filters

screen.

In the

Rules

pane, click

Actions

Create Rule

In the

Name

field, enter

FirstName

In the

Expression

section, enter the following expression to separate the first name from the

Name

column:

SUBSTR(FullName,1,INSTR(FullName,' ' ,-1,1 ) - 1)

Click

Validate

Click

Repeat steps 4 through 8 to create a rule named

LastName

. Enter the following expression to separate the last name from the

Name

column:

SUBSTR(FullName,INSTR(FullName,' ',-1,1),LENGTH(FullName))

Click

Save and Run

to save and run the profile.

Lesson 5. Creating Expression Rules

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

Profiling Getting Started Guide

Profiling Getting Started Guide

Task 1. Create Expression Rules and Run the Profile

Task 1. Create Expression Rules and Run the Profile