| <?xml version="1.0" encoding="UTF-8"?> |
| <pipeline> |
| <info> |
| <name>JavaScript create new rows</name> |
| <description/> |
| <extended_description/> |
| <trans_version/> |
| <trans_type>Normal</trans_type> |
| <directory>/</directory> |
| <parameters> |
| </parameters> |
| <log> |
| <pipeline-log-table> |
| <connection/> |
| <schema/> |
| <table/> |
| <size_limit_lines/> |
| <interval/> |
| <timeout_days/> |
| <field> |
| <id>ID_BATCH</id> |
| <enabled>Y</enabled> |
| <name>ID_BATCH</name> |
| </field> |
| <field> |
| <id>CHANNEL_ID</id> |
| <enabled>N</enabled> |
| <name>CHANNEL_ID</name> |
| </field> |
| <field> |
| <id>TRANSNAME</id> |
| <enabled>Y</enabled> |
| <name>TRANSNAME</name> |
| </field> |
| <field> |
| <id>STATUS</id> |
| <enabled>Y</enabled> |
| <name>STATUS</name> |
| </field> |
| <field> |
| <id>LINES_READ</id> |
| <enabled>Y</enabled> |
| <name>LINES_READ</name> |
| <subject/> |
| </field> |
| <field> |
| <id>LINES_WRITTEN</id> |
| <enabled>Y</enabled> |
| <name>LINES_WRITTEN</name> |
| <subject/> |
| </field> |
| <field> |
| <id>LINES_UPDATED</id> |
| <enabled>Y</enabled> |
| <name>LINES_UPDATED</name> |
| <subject/> |
| </field> |
| <field> |
| <id>LINES_INPUT</id> |
| <enabled>Y</enabled> |
| <name>LINES_INPUT</name> |
| <subject/> |
| </field> |
| <field> |
| <id>LINES_OUTPUT</id> |
| <enabled>Y</enabled> |
| <name>LINES_OUTPUT</name> |
| <subject/> |
| </field> |
| <field> |
| <id>LINES_REJECTED</id> |
| <enabled>N</enabled> |
| <name>LINES_REJECTED</name> |
| <subject/> |
| </field> |
| <field> |
| <id>ERRORS</id> |
| <enabled>Y</enabled> |
| <name>ERRORS</name> |
| </field> |
| <field> |
| <id>STARTDATE</id> |
| <enabled>Y</enabled> |
| <name>STARTDATE</name> |
| </field> |
| <field> |
| <id>ENDDATE</id> |
| <enabled>Y</enabled> |
| <name>ENDDATE</name> |
| </field> |
| <field> |
| <id>LOGDATE</id> |
| <enabled>Y</enabled> |
| <name>LOGDATE</name> |
| </field> |
| <field> |
| <id>DEPDATE</id> |
| <enabled>Y</enabled> |
| <name>DEPDATE</name> |
| </field> |
| <field> |
| <id>REPLAYDATE</id> |
| <enabled>Y</enabled> |
| <name>REPLAYDATE</name> |
| </field> |
| <field> |
| <id>LOG_FIELD</id> |
| <enabled>N</enabled> |
| <name>LOG_FIELD</name> |
| </field> |
| <field> |
| <id>EXECUTING_SERVER</id> |
| <enabled>N</enabled> |
| <name>EXECUTING_SERVER</name> |
| </field> |
| <field> |
| <id>EXECUTING_USER</id> |
| <enabled>N</enabled> |
| <name>EXECUTING_USER</name> |
| </field> |
| <field> |
| <id>CLIENT</id> |
| <enabled>N</enabled> |
| <name>CLIENT</name> |
| </field> |
| </pipeline-log-table> |
| <perf-log-table> |
| <connection/> |
| <schema/> |
| <table/> |
| <interval/> |
| <timeout_days/> |
| <field> |
| <id>ID_BATCH</id> |
| <enabled>Y</enabled> |
| <name>ID_BATCH</name> |
| </field> |
| <field> |
| <id>SEQ_NR</id> |
| <enabled>Y</enabled> |
| <name>SEQ_NR</name> |
| </field> |
| <field> |
| <id>LOGDATE</id> |
| <enabled>Y</enabled> |
| <name>LOGDATE</name> |
| </field> |
| <field> |
| <id>TRANSNAME</id> |
| <enabled>Y</enabled> |
| <name>TRANSNAME</name> |
| </field> |
| <field> |
| <id>STEPNAME</id> |
| <enabled>Y</enabled> |
| <name>STEPNAME</name> |
| </field> |
| <field> |
| <id>STEP_COPY</id> |
| <enabled>Y</enabled> |
| <name>STEP_COPY</name> |
| </field> |
| <field> |
| <id>LINES_READ</id> |
| <enabled>Y</enabled> |
| <name>LINES_READ</name> |
| </field> |
| <field> |
| <id>LINES_WRITTEN</id> |
| <enabled>Y</enabled> |
| <name>LINES_WRITTEN</name> |
| </field> |
| <field> |
| <id>LINES_UPDATED</id> |
| <enabled>Y</enabled> |
| <name>LINES_UPDATED</name> |
| </field> |
| <field> |
| <id>LINES_INPUT</id> |
| <enabled>Y</enabled> |
| <name>LINES_INPUT</name> |
| </field> |
| <field> |
| <id>LINES_OUTPUT</id> |
| <enabled>Y</enabled> |
| <name>LINES_OUTPUT</name> |
| </field> |
| <field> |
| <id>LINES_REJECTED</id> |
| <enabled>Y</enabled> |
| <name>LINES_REJECTED</name> |
| </field> |
| <field> |
| <id>ERRORS</id> |
| <enabled>Y</enabled> |
| <name>ERRORS</name> |
| </field> |
| <field> |
| <id>INPUT_BUFFER_ROWS</id> |
| <enabled>Y</enabled> |
| <name>INPUT_BUFFER_ROWS</name> |
| </field> |
| <field> |
| <id>OUTPUT_BUFFER_ROWS</id> |
| <enabled>Y</enabled> |
| <name>OUTPUT_BUFFER_ROWS</name> |
| </field> |
| </perf-log-table> |
| <channel-log-table> |
| <connection/> |
| <schema/> |
| <table/> |
| <timeout_days/> |
| <field> |
| <id>ID_BATCH</id> |
| <enabled>Y</enabled> |
| <name>ID_BATCH</name> |
| </field> |
| <field> |
| <id>CHANNEL_ID</id> |
| <enabled>Y</enabled> |
| <name>CHANNEL_ID</name> |
| </field> |
| <field> |
| <id>LOG_DATE</id> |
| <enabled>Y</enabled> |
| <name>LOG_DATE</name> |
| </field> |
| <field> |
| <id>LOGGING_OBJECT_TYPE</id> |
| <enabled>Y</enabled> |
| <name>LOGGING_OBJECT_TYPE</name> |
| </field> |
| <field> |
| <id>OBJECT_NAME</id> |
| <enabled>Y</enabled> |
| <name>OBJECT_NAME</name> |
| </field> |
| <field> |
| <id>OBJECT_COPY</id> |
| <enabled>Y</enabled> |
| <name>OBJECT_COPY</name> |
| </field> |
| <field> |
| <id>REPOSITORY_DIRECTORY</id> |
| <enabled>Y</enabled> |
| <name>REPOSITORY_DIRECTORY</name> |
| </field> |
| <field> |
| <id>FILENAME</id> |
| <enabled>Y</enabled> |
| <name>FILENAME</name> |
| </field> |
| <field> |
| <id>OBJECT_ID</id> |
| <enabled>Y</enabled> |
| <name>OBJECT_ID</name> |
| </field> |
| <field> |
| <id>OBJECT_REVISION</id> |
| <enabled>Y</enabled> |
| <name>OBJECT_REVISION</name> |
| </field> |
| <field> |
| <id>PARENT_CHANNEL_ID</id> |
| <enabled>Y</enabled> |
| <name>PARENT_CHANNEL_ID</name> |
| </field> |
| <field> |
| <id>ROOT_CHANNEL_ID</id> |
| <enabled>Y</enabled> |
| <name>ROOT_CHANNEL_ID</name> |
| </field> |
| </channel-log-table> |
| <transform-log-table> |
| <connection/> |
| <schema/> |
| <table/> |
| <timeout_days/> |
| <field> |
| <id>ID_BATCH</id> |
| <enabled>Y</enabled> |
| <name>ID_BATCH</name> |
| </field> |
| <field> |
| <id>CHANNEL_ID</id> |
| <enabled>Y</enabled> |
| <name>CHANNEL_ID</name> |
| </field> |
| <field> |
| <id>LOG_DATE</id> |
| <enabled>Y</enabled> |
| <name>LOG_DATE</name> |
| </field> |
| <field> |
| <id>TRANSNAME</id> |
| <enabled>Y</enabled> |
| <name>TRANSNAME</name> |
| </field> |
| <field> |
| <id>STEPNAME</id> |
| <enabled>Y</enabled> |
| <name>STEPNAME</name> |
| </field> |
| <field> |
| <id>STEP_COPY</id> |
| <enabled>Y</enabled> |
| <name>STEP_COPY</name> |
| </field> |
| <field> |
| <id>LINES_READ</id> |
| <enabled>Y</enabled> |
| <name>LINES_READ</name> |
| </field> |
| <field> |
| <id>LINES_WRITTEN</id> |
| <enabled>Y</enabled> |
| <name>LINES_WRITTEN</name> |
| </field> |
| <field> |
| <id>LINES_UPDATED</id> |
| <enabled>Y</enabled> |
| <name>LINES_UPDATED</name> |
| </field> |
| <field> |
| <id>LINES_INPUT</id> |
| <enabled>Y</enabled> |
| <name>LINES_INPUT</name> |
| </field> |
| <field> |
| <id>LINES_OUTPUT</id> |
| <enabled>Y</enabled> |
| <name>LINES_OUTPUT</name> |
| </field> |
| <field> |
| <id>LINES_REJECTED</id> |
| <enabled>Y</enabled> |
| <name>LINES_REJECTED</name> |
| </field> |
| <field> |
| <id>ERRORS</id> |
| <enabled>Y</enabled> |
| <name>ERRORS</name> |
| </field> |
| <field> |
| <id>LOG_FIELD</id> |
| <enabled>N</enabled> |
| <name>LOG_FIELD</name> |
| </field> |
| </transform-log-table> |
| <metrics-log-table> |
| <connection/> |
| <schema/> |
| <table/> |
| <timeout_days/> |
| <field> |
| <id>ID_BATCH</id> |
| <enabled>Y</enabled> |
| <name>ID_BATCH</name> |
| </field> |
| <field> |
| <id>CHANNEL_ID</id> |
| <enabled>Y</enabled> |
| <name>CHANNEL_ID</name> |
| </field> |
| <field> |
| <id>LOG_DATE</id> |
| <enabled>Y</enabled> |
| <name>LOG_DATE</name> |
| </field> |
| <field> |
| <id>METRICS_DATE</id> |
| <enabled>Y</enabled> |
| <name>METRICS_DATE</name> |
| </field> |
| <field> |
| <id>METRICS_CODE</id> |
| <enabled>Y</enabled> |
| <name>METRICS_CODE</name> |
| </field> |
| <field> |
| <id>METRICS_DESCRIPTION</id> |
| <enabled>Y</enabled> |
| <name>METRICS_DESCRIPTION</name> |
| </field> |
| <field> |
| <id>METRICS_SUBJECT</id> |
| <enabled>Y</enabled> |
| <name>METRICS_SUBJECT</name> |
| </field> |
| <field> |
| <id>METRICS_TYPE</id> |
| <enabled>Y</enabled> |
| <name>METRICS_TYPE</name> |
| </field> |
| <field> |
| <id>METRICS_VALUE</id> |
| <enabled>Y</enabled> |
| <name>METRICS_VALUE</name> |
| </field> |
| </metrics-log-table> |
| </log> |
| <maxdate> |
| <connection/> |
| <table/> |
| <field/> |
| <offset>0.0</offset> |
| <maxdiff>0.0</maxdiff> |
| </maxdate> |
| <size_rowset>1000</size_rowset> |
| <sleep_time_empty>1</sleep_time_empty> |
| <sleep_time_full>1</sleep_time_full> |
| <unique_connections>N</unique_connections> |
| <feedback_shown>Y</feedback_shown> |
| <feedback_size>50000</feedback_size> |
| <using_thread_priorities>Y</using_thread_priorities> |
| <shared_objects_file/> |
| <capture_transform_performance>N</capture_transform_performance> |
| <transform_performance_capturing_delay>1000</transform_performance_capturing_delay> |
| <transform_performance_capturing_size_limit/> |
| <dependencies> |
| </dependencies> |
| <partitionschemas> |
| </partitionschemas> |
| <slaveservers> |
| </slaveservers> |
| <clusterschemas> |
| </clusterschemas> |
| <created_user/> |
| <created_date>2014/03/03 20:39:04.310</created_date> |
| <modified_user>-</modified_user> |
| <modified_date>2006/10/31 19:27:10.437</modified_date> |
| <key_for_session_key>H4sIAAAAAAAAAAMAAAAAAAAAAAA=</key_for_session_key> |
| <is_key_private>N</is_key_private> |
| </info> |
| <notepads> |
| </notepads> |
| <order> |
| <hop> |
| <from>Java Script Value</from> |
| <to>Filter rows</to> |
| <enabled>Y</enabled> |
| </hop> |
| <hop> |
| <from>Generate Rows 2</from> |
| <to>Dummy (do nothing)</to> |
| <enabled>Y</enabled> |
| </hop> |
| <hop> |
| <from>Generate Rows</from> |
| <to>Dummy (do nothing)</to> |
| <enabled>Y</enabled> |
| </hop> |
| <hop> |
| <from>Dummy (do nothing)</from> |
| <to>Java Script Value</to> |
| <enabled>Y</enabled> |
| </hop> |
| </order> |
| <transform> |
| <name>Dummy (do nothing)</name> |
| <type>Dummy</type> |
| <description/> |
| <distribute>Y</distribute> |
| <custom_distribution/> |
| <copies>1</copies> |
| <partitioning> |
| <method>none</method> |
| <schema_name/> |
| </partitioning> |
| <cluster_schema/> |
| |
| <input> |
| </input> |
| <output> |
| </output> |
| |
| <GUI> |
| <xloc>199</xloc> |
| <yloc>128</yloc> |
| <draw>Y</draw> |
| </GUI> |
| </transform> |
| |
| <transform> |
| <name>Filter rows</name> |
| <type>FilterRows</type> |
| <description/> |
| <distribute>Y</distribute> |
| <custom_distribution/> |
| <copies>1</copies> |
| <partitioning> |
| <method>none</method> |
| <schema_name/> |
| </partitioning> |
| <send_true_to/> |
| <send_false_to/> |
| <compare> |
| <condition> |
| <negated>N</negated> |
| <leftvalue>ignore</leftvalue> |
| <function>=</function> |
| <rightvalue/> |
| <value><name>constant</name><type>String</type><text>N</text><length>-1</length><precision>-1</precision><isnull>N</isnull><mask/></value> </condition> |
| </compare> |
| <cluster_schema/> |
| |
| <input> |
| </input> |
| <output> |
| </output> |
| |
| <GUI> |
| <xloc>501</xloc> |
| <yloc>128</yloc> |
| <draw>Y</draw> |
| </GUI> |
| </transform> |
| |
| <transform> |
| <name>Generate Rows</name> |
| <type>RowGenerator</type> |
| <description/> |
| <distribute>Y</distribute> |
| <custom_distribution/> |
| <copies>1</copies> |
| <partitioning> |
| <method>none</method> |
| <schema_name/> |
| </partitioning> |
| <fields> |
| <field> |
| <name>member</name> |
| <type>String</type> |
| <format/> |
| <currency/> |
| <decimal/> |
| <group/> |
| <nullif>Member 1</nullif> |
| <length>100</length> |
| <precision>-1</precision> |
| <set_empty_string>N</set_empty_string> |
| </field> |
| <field> |
| <name>groupsField</name> |
| <type>String</type> |
| <format/> |
| <currency/> |
| <decimal/> |
| <group/> |
| <nullif>Group1, Group2, Group3, Group4</nullif> |
| <length>100</length> |
| <precision>-1</precision> |
| <set_empty_string>N</set_empty_string> |
| </field> |
| </fields> |
| <limit>1</limit> |
| <never_ending>N</never_ending> |
| <interval_in_ms/> |
| <row_time_field/> |
| <last_time_field/> |
| <cluster_schema/> |
| |
| <input> |
| </input> |
| <output> |
| </output> |
| |
| <GUI> |
| <xloc>97</xloc> |
| <yloc>77</yloc> |
| <draw>Y</draw> |
| </GUI> |
| </transform> |
| |
| <transform> |
| <name>Generate Rows 2</name> |
| <type>RowGenerator</type> |
| <description/> |
| <distribute>Y</distribute> |
| <custom_distribution/> |
| <copies>1</copies> |
| <partitioning> |
| <method>none</method> |
| <schema_name/> |
| </partitioning> |
| <fields> |
| <field> |
| <name>member</name> |
| <type>String</type> |
| <format/> |
| <currency/> |
| <decimal/> |
| <group/> |
| <nullif>Member 2</nullif> |
| <length>100</length> |
| <precision>-1</precision> |
| <set_empty_string>N</set_empty_string> |
| </field> |
| <field> |
| <name>groupsField</name> |
| <type>String</type> |
| <format/> |
| <currency/> |
| <decimal/> |
| <group/> |
| <nullif>Group1, Group2</nullif> |
| <length>100</length> |
| <precision>-1</precision> |
| <set_empty_string>N</set_empty_string> |
| </field> |
| </fields> |
| <limit>1</limit> |
| <never_ending>N</never_ending> |
| <interval_in_ms/> |
| <row_time_field/> |
| <last_time_field/> |
| <cluster_schema/> |
| |
| <input> |
| </input> |
| <output> |
| </output> |
| |
| <GUI> |
| <xloc>96</xloc> |
| <yloc>170</yloc> |
| <draw>Y</draw> |
| </GUI> |
| </transform> |
| |
| <transform> |
| <name>Java Script Value</name> |
| <type>ScriptValueMod</type> |
| <description/> |
| <distribute>Y</distribute> |
| <custom_distribution/> |
| <copies>1</copies> |
| <partitioning> |
| <method>none</method> |
| <schema_name/> |
| </partitioning> |
| <compatible>N</compatible> |
| <optimizationLevel/> |
| <jsScripts> <jsScript> <jsScript_type>0</jsScript_type> |
| <jsScript_name>ScriptValue</jsScript_name> |
| <jsScript_script>
if (groupsField!=null) 
{
 var groups = groupsField.split(",");
 
 for (i=0;i<groups.length;i++)
 {
 newRow = createRowCopy(getOutputRowMeta().size());
 var rowIndex = getInputRowMeta().size();

 newRow[rowIndex++] = trim( groups[i] );
 newRow[rowIndex++] = "N";

 putRow(newRow);
 }
}

var subgroup = "";
var ignore = "Y";</jsScript_script> |
| </jsScript> </jsScripts> <fields> <field> <name>subgroup</name> |
| <rename>subgroup</rename> |
| <type>String</type> |
| <length>100</length> |
| <precision>-1</precision> |
| <replace>N</replace> |
| </field> <field> <name>ignore</name> |
| <rename>ignore</rename> |
| <type>String</type> |
| <length>1</length> |
| <precision>-1</precision> |
| <replace>N</replace> |
| </field> </fields> <cluster_schema/> |
| |
| <input> |
| </input> |
| <output> |
| </output> |
| |
| <GUI> |
| <xloc>350</xloc> |
| <yloc>128</yloc> |
| <draw>Y</draw> |
| </GUI> |
| </transform> |
| |
| <transform_error_handling> |
| </transform_error_handling> |
| <slave-transform-copy-partition-distribution> |
| </slave-transform-copy-partition-distribution> |
| <slave_transformation>N</slave_transformation> |
| </pipeline> |
