Overview

The Alphanumeric to Numeric ID Processor converts an alphanumeric ID (an ID that contains numbers and letters) to a numeric one. 

Input

The processor can operate on any valid dataset that contains an alphanumeric ID.

Configuration

Column to Convert: Select the column that contains the alphanumeric IDs that should be converted to a numeric ID.

Output

The processor has two output nodes.

The first (left) output node returns the original input dataset with an additional column that contains the converted numeric ID.

The second (right) output node returns a table with the mapping of the alphanumeric IDs to the numeric IDs which can be useful for reconverting the IDs later on.

The ordering of the result is random.

Addition

The processor might be especially useful when using the ALS Recommender Processor as this processor requires a numeric ID.

Example

In this example, we used a Custom Input Table Processor to create a dataset containing alphanumeric ID's and used the Alphanumeric to Numeric ID Processor to convert these IDs to numeric ones.

Input

Workflow

Configuration

In the configuration menu the "ID" column is selected, which contains the alphanumeric id.

Result

Output Result Table "Numeric IDs with data": 

Output Result Table "Numeric IDs":