OtherFieldValue

Generator

Distribution

Output

Scheduler

Misc.

Tags

OtherFieldValue

Writes out the field value generated in another field in the same table. Needs a <reference> element as content which defines the reference to use.

Attributes
Name Description Required Min Max Allowed Values
name (Class)Name of this element. Used to identify plugin Class. Full name is required. Example: com.en.myPluginPackage.myPuginClass no 0 1
id Identification String of this element. May be used to uniquely identify a field within the children of an Element. no 0 1
Nodes
Name Description Required Min Max Allowed Values
reference reference yes 1 1

Example

  1. Person with Email Address

    reference other email sequential

    Generates email addresses based on the given first and last name of a person.

    Schema config for Person with Email Address
    <?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!--
/*******************************************************************************
* Copyright (c) 2013, bankmark and/or its affiliates. All rights reserved.
* bankmark UG PROPRIETARY/CONFIDENTIAL. Use is subject to license terms.
******************************************************************************/
--><schema xmlns:doc="http://bankmark.de/pdgf/doc" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" name="demo" xsi:noNamespaceSchemaLocation="structure/pdgfSchema.xsd">
  <!-- All data is derived from this starting seed.
       If this seed is the same, the generated data will the same on each
       computer/node/platform.
       Change this seed to generate a different data set.-->
  <seed>1234567890L</seed>

  <rng name="PdgfDefaultRandom"/>

  <!--Default Scale factor for all tables -->
  <property name="SF" type="double">1</property>

  <table name="PERSON">
    <!-- if tables should scale with -SF command line argument.
         Specify your scaling formula here: -->
    <size>10 * ${SF}</size>

    <!--Person with Email Address-->
      <!--Generates email addresses based on the given first and last name of a person.-->
      <field name="first_name" type="VARCHAR">
        <gen_DictList id="first_name_gen">
          <file>dicts/Given-Names.dict</file>
        </gen_DictList>
      </field>
      <field name="last_name" type="VARCHAR">
        <gen_DictList id="last_name_gen">
          <file>dicts/Family-Names.dict</file>
        </gen_DictList>
      </field>
      <field name="company_email" size="" type="VARCHAR">
        <gen_Sequential concatenateResults="true">
          <gen_OtherFieldValue>
            <reference field="first_name"/>
          </gen_OtherFieldValue>

          <gen_StaticValue>
            <value>.</value>
          </gen_StaticValue>

          <gen_OtherFieldValue>
            <reference field="last_name"/>
          </gen_OtherFieldValue>

          <gen_StaticValue>
            <value>@company.com</value>
          </gen_StaticValue>
        </gen_Sequential>
      </field>
      </table>
</schema>
    Output for Person with Email Address
    Annie|Pai|Annie.Pai@company.com
Helma|Pietrzak|Helma.Pietrzak@company.com
Ruthe|Gregory|Ruthe.Gregory@company.com
Krystn|Konno|Krystn.Konno@company.com
Ilyse|Xavier|Ilyse.Xavier@company.com
Ermina|Najafi|Ermina.Najafi@company.com
Jayendra|VMXA|Jayendra.VMXA@company.com
Cuong|Zumhagen|Cuong.Zumhagen@company.com
Bev|Bates|Bev.Bates@company.com
Jacquelynn|Crompton|Jacquelynn.Crompton@company.com
2.7-83fb0 | 2020-04-22