Consumption Analytics Documentation

Home > Documentation for older versions > Cloud Cruiser 3 > Batch XML Reference > Transform processors > CreateIdentifierFromTable


Creates a new identifier from a lookup table using an existing identifier value. The lookup table can be a flat file or a Translate Table Revision from the database. Each lookup table entry consists of a either a value range or a pattern along with a target identifier value. For each record, the value of the source identifier is compared to each table entry, in order, until a match is found or the end of the table is reached. In the case of a match, the value for the first matching row is used to create/update the target identifier in the current record. In the case of input records that result in no match, the behavior depends on the exception processing settings.

For more information on exception processing, see Exception processing.




Name Type Description
exceptionProcessing​​ boolean When true, any input record that does not result in a match is an exception. When false, the sourceIdentifier value is copied to the target identifier.
lookupFile string

Specifies a resource to a flat file translation table in the format file:<path>. For example, file:${env.processingDir}/tables/validUIDs/

Specify either this property or translateTitle.

overwrite boolean When true, the value for targetIdentifier is set even if the identifier already exists in the record being processed. When false, an existing value is left alone.
sourceIdentifier type Specifies an identifier whose value is matched in the translation table. An error occurs if an input record does not contain this identifier.
targetIdentifier string Specifies an identifier to receive the translated value. Default is @acctid.
translateTitle string

Sets the title of the managed translation table to be used. Managed translation tables are maintained using the Cloud Cruiser application. There can be multiple revisions for a translation. The revision that is in effect for the accounting date of the active job is applied.

Specify either this property or lookupFile.

Spring Batch XML example

<batch:step id="transform" next="charge">
    <bean class="com.cloudcruiser.batch.CCRecordTransformTasklet">
      <property name="processors">
          <bean class="com.cloudcruiser.batch.transform.CreateIdentifierFromTable">
            <property name="active" value="true" />
            <property name="translateTitle" value="default" />
            <property name="sourceIdentifier" value="IP" />
            <property name="targetIdentifier" value="@acctid" />
            <property name="overwrite" value="true" />
            <property name="exceptionProcessing" value="true" />
Last modified


This page has no custom tags.


This page has no classifications.

 (c) Copyright 2017-2020 Hewlett Packard Enterprise Development LP