| <?xml version="1.0" encoding="UTF-8"?> |
| <pipeline> |
| <info> |
| <name>Create groups in the changelog data</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/02/26 12:55:58.788</created_date> |
| <modified_user>-</modified_user> |
| <modified_date>2006/10/19 11:28:22.781</modified_date> |
| <key_for_session_key>H4sIAAAAAAAAAAMAAAAAAAAAAAA=</key_for_session_key> |
| <is_key_private>N</is_key_private> |
| </info> |
| <notepads> |
| </notepads> |
| <connection> |
| <name>SampleData.H2</name> |
| <server/> |
| <type>H2</type> |
| <access>JNDI</access> |
| <database>SampleData</database> |
| <port>1521</port> |
| <username/> |
| <password>Encrypted </password> |
| <servername/> |
| <data_tablespace/> |
| <index_tablespace/> |
| <attributes> |
| <attribute><code>FORCE_IDENTIFIERS_TO_LOWERCASE</code><attribute>N</attribute></attribute> |
| <attribute><code>FORCE_IDENTIFIERS_TO_UPPERCASE</code><attribute>N</attribute></attribute> |
| <attribute><code>IS_CLUSTERED</code><attribute>N</attribute></attribute> |
| <attribute><code>PORT_NUMBER</code><attribute>1521</attribute></attribute> |
| <attribute><code>PRESERVE_RESERVED_WORD_CASE</code><attribute>N</attribute></attribute> |
| <attribute><code>QUOTE_ALL_FIELDS</code><attribute>N</attribute></attribute> |
| <attribute><code>SUPPORTS_BOOLEAN_DATA_TYPE</code><attribute>Y</attribute></attribute> |
| <attribute><code>SUPPORTS_TIMESTAMP_DATA_TYPE</code><attribute>Y</attribute></attribute> |
| <attribute><code>USE_POOLING</code><attribute>N</attribute></attribute> |
| </attributes> |
| </connection> |
| <order> |
| <hop> |
| <from>changelog.txt</from> |
| <to>nr</to> |
| <enabled>Y</enabled> |
| </hop> |
| <hop> |
| <from>nr</from> |
| <to>sort on id, seq</to> |
| <enabled>Y</enabled> |
| </hop> |
| <hop> |
| <from>sort on id, seq</from> |
| <to>subnr</to> |
| <enabled>Y</enabled> |
| </hop> |
| <hop> |
| <from>subnr</from> |
| <to>TMP_CHANGELOG</to> |
| <enabled>Y</enabled> |
| </hop> |
| <hop> |
| <from>sort on subnr</from> |
| <to>distinct subnr</to> |
| <enabled>Y</enabled> |
| </hop> |
| <hop> |
| <from>TMP_CHANGELOG</from> |
| <to>Only subnr</to> |
| <enabled>Y</enabled> |
| </hop> |
| <hop> |
| <from>Only subnr</from> |
| <to>sort on subnr</to> |
| <enabled>Y</enabled> |
| </hop> |
| <hop> |
| <from>distinct subnr</from> |
| <to>Copy rows to result</to> |
| <enabled>Y</enabled> |
| </hop> |
| </order> |
| <transform> |
| <name>Copy rows to result</name> |
| <type>RowsToResult</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>377</xloc> |
| <yloc>507</yloc> |
| <draw>Y</draw> |
| </GUI> |
| </transform> |
| |
| <transform> |
| <name>Only subnr</name> |
| <type>SelectValues</type> |
| <description/> |
| <distribute>Y</distribute> |
| <custom_distribution/> |
| <copies>1</copies> |
| <partitioning> |
| <method>none</method> |
| <schema_name/> |
| </partitioning> |
| <fields> <field> <name>subnr</name> |
| </field> <select_unspecified>N</select_unspecified> |
| </fields> <cluster_schema/> |
| |
| <input> |
| </input> |
| <output> |
| </output> |
| |
| <GUI> |
| <xloc>377</xloc> |
| <yloc>204</yloc> |
| <draw>Y</draw> |
| </GUI> |
| </transform> |
| |
| <transform> |
| <name>TMP_CHANGELOG</name> |
| <type>TableOutput</type> |
| <description/> |
| <distribute>Y</distribute> |
| <custom_distribution/> |
| <copies>1</copies> |
| <partitioning> |
| <method>none</method> |
| <schema_name/> |
| </partitioning> |
| <connection>SampleData.H2</connection> |
| <schema/> |
| <table>TMP_CHANGELOG</table> |
| <commit>100</commit> |
| <truncate>Y</truncate> |
| <ignore_errors>N</ignore_errors> |
| <use_batch>Y</use_batch> |
| <specify_fields>N</specify_fields> |
| <partitioning_enabled>N</partitioning_enabled> |
| <partitioning_field/> |
| <partitioning_daily>N</partitioning_daily> |
| <partitioning_monthly>Y</partitioning_monthly> |
| <tablename_in_field>N</tablename_in_field> |
| <tablename_field/> |
| <tablename_in_table>Y</tablename_in_table> |
| <return_keys>N</return_keys> |
| <return_field/> |
| <fields> |
| </fields> |
| <cluster_schema/> |
| |
| <input> |
| </input> |
| <output> |
| </output> |
| |
| <GUI> |
| <xloc>591</xloc> |
| <yloc>78</yloc> |
| <draw>Y</draw> |
| </GUI> |
| </transform> |
| |
| <transform> |
| <name>changelog.txt</name> |
| <type>TextFileInput</type> |
| <description/> |
| <distribute>Y</distribute> |
| <custom_distribution/> |
| <copies>1</copies> |
| <partitioning> |
| <method>none</method> |
| <schema_name/> |
| </partitioning> |
| <accept_filenames>N</accept_filenames> |
| <passing_through_fields>N</passing_through_fields> |
| <accept_field/> |
| <accept_transformname/> |
| <separator>;</separator> |
| <enclosure>"</enclosure> |
| <enclosure_breaks>N</enclosure_breaks> |
| <escapechar/> |
| <header>Y</header> |
| <nr_headerlines>1</nr_headerlines> |
| <footer>N</footer> |
| <nr_footerlines>1</nr_footerlines> |
| <line_wrapped>N</line_wrapped> |
| <nr_wraps>1</nr_wraps> |
| <layout_paged>N</layout_paged> |
| <nr_lines_per_page>80</nr_lines_per_page> |
| <nr_lines_doc_header>0</nr_lines_doc_header> |
| <noempty>Y</noempty> |
| <include>N</include> |
| <include_field/> |
| <rownum>N</rownum> |
| <rownumByFile>N</rownumByFile> |
| <rownum_field/> |
| <format>mixed</format> |
| <encoding/> |
| <add_to_result_filenames>Y</add_to_result_filenames> |
| <file> |
| <name>${Internal.Transformation.Filename.Directory}/../../transformations/files/changelog.txt</name> |
| <filemask/> |
| <exclude_filemask/> |
| <file_required>N</file_required> |
| <include_subfolders>N</include_subfolders> |
| <type>CSV</type> |
| <compression>None</compression> |
| </file> |
| <filters> |
| </filters> |
| <fields> |
| <field> |
| <name>flag</name> |
| <type>String</type> |
| <format/> |
| <currency/> |
| <decimal/> |
| <group/> |
| <nullif>-</nullif> |
| <ifnull/> |
| <position>-1</position> |
| <length>1</length> |
| <precision>-1</precision> |
| <trim_type>none</trim_type> |
| <repeat>N</repeat> |
| </field> |
| <field> |
| <name>id</name> |
| <type>Integer</type> |
| <format/> |
| <currency>€</currency> |
| <decimal>,</decimal> |
| <group>.</group> |
| <nullif>-</nullif> |
| <ifnull/> |
| <position>-1</position> |
| <length>2</length> |
| <precision>0</precision> |
| <trim_type>none</trim_type> |
| <repeat>N</repeat> |
| </field> |
| <field> |
| <name>foo</name> |
| <type>String</type> |
| <format/> |
| <currency/> |
| <decimal/> |
| <group/> |
| <nullif>-</nullif> |
| <ifnull/> |
| <position>-1</position> |
| <length>10</length> |
| <precision>-1</precision> |
| <trim_type>none</trim_type> |
| <repeat>N</repeat> |
| </field> |
| </fields> |
| <limit>0</limit> |
| <error_ignored>N</error_ignored> |
| <skip_bad_files>N</skip_bad_files> |
| <file_error_field/> |
| <file_error_message_field/> |
| <error_line_skipped>N</error_line_skipped> |
| <error_count_field/> |
| <error_fields_field/> |
| <error_text_field/> |
| <bad_line_files_destination_directory/> |
| <bad_line_files_extension>warning</bad_line_files_extension> |
| <error_line_files_destination_directory/> |
| <error_line_files_extension>error</error_line_files_extension> |
| <line_number_files_destination_directory/> |
| <line_number_files_extension>line</line_number_files_extension> |
| <date_format_lenient>Y</date_format_lenient> |
| <date_format_locale>nl_NL</date_format_locale> |
| <shortFileFieldName/> |
| <pathFieldName/> |
| <hiddenFieldName/> |
| <lastModificationTimeFieldName/> |
| <uriNameFieldName/> |
| <rootUriNameFieldName/> |
| <extensionFieldName/> |
| <sizeFieldName/> |
| <cluster_schema/> |
| |
| <input> |
| </input> |
| <output> |
| </output> |
| |
| <GUI> |
| <xloc>115</xloc> |
| <yloc>77</yloc> |
| <draw>Y</draw> |
| </GUI> |
| </transform> |
| |
| <transform> |
| <name>distinct subnr</name> |
| <type>Unique</type> |
| <description/> |
| <distribute>Y</distribute> |
| <custom_distribution/> |
| <copies>1</copies> |
| <partitioning> |
| <method>none</method> |
| <schema_name/> |
| </partitioning> |
| <count_rows>N</count_rows> |
| <count_field/> |
| <reject_duplicate_row>N</reject_duplicate_row> |
| <error_description/> |
| <fields> </fields> <cluster_schema/> |
| |
| <input> |
| </input> |
| <output> |
| </output> |
| |
| <GUI> |
| <xloc>377</xloc> |
| <yloc>406</yloc> |
| <draw>Y</draw> |
| </GUI> |
| </transform> |
| |
| <transform> |
| <name>nr</name> |
| <type>Sequence</type> |
| <description/> |
| <distribute>Y</distribute> |
| <custom_distribution/> |
| <copies>1</copies> |
| <partitioning> |
| <method>none</method> |
| <schema_name/> |
| </partitioning> |
| <valuename>nr</valuename> |
| <use_database>N</use_database> |
| <connection/> |
| <schema/> |
| <seqname>SEQ_</seqname> |
| <use_counter>Y</use_counter> |
| <counter_name/> |
| <start_at>1</start_at> |
| <increment_by>1</increment_by> |
| <max_value>9999999</max_value> |
| <cluster_schema/> |
| |
| <input> |
| </input> |
| <output> |
| </output> |
| |
| <GUI> |
| <xloc>234</xloc> |
| <yloc>77</yloc> |
| <draw>Y</draw> |
| </GUI> |
| </transform> |
| |
| <transform> |
| <name>sort on id, seq</name> |
| <type>SortRows</type> |
| <description/> |
| <distribute>Y</distribute> |
| <custom_distribution/> |
| <copies>1</copies> |
| <partitioning> |
| <method>none</method> |
| <schema_name/> |
| </partitioning> |
| <directory>%%java.io.tmpdir%%</directory> |
| <prefix>out</prefix> |
| <sort_size>5000</sort_size> |
| <free_memory/> |
| <compress>N</compress> |
| <compress_variable/> |
| <unique_rows>N</unique_rows> |
| <fields> |
| <field> |
| <name>id</name> |
| <ascending>Y</ascending> |
| <case_sensitive>Y</case_sensitive> |
| <collator_enabled>N</collator_enabled> |
| <collator_strength>0</collator_strength> |
| <presorted>N</presorted> |
| </field> |
| <field> |
| <name>nr</name> |
| <ascending>Y</ascending> |
| <case_sensitive>Y</case_sensitive> |
| <collator_enabled>N</collator_enabled> |
| <collator_strength>0</collator_strength> |
| <presorted>N</presorted> |
| </field> |
| </fields> |
| <cluster_schema/> |
| |
| <input> |
| </input> |
| <output> |
| </output> |
| |
| <GUI> |
| <xloc>353</xloc> |
| <yloc>77</yloc> |
| <draw>Y</draw> |
| </GUI> |
| </transform> |
| |
| <transform> |
| <name>sort on subnr</name> |
| <type>SortRows</type> |
| <description/> |
| <distribute>Y</distribute> |
| <custom_distribution/> |
| <copies>1</copies> |
| <partitioning> |
| <method>none</method> |
| <schema_name/> |
| </partitioning> |
| <directory>%%java.io.tmpdir%%</directory> |
| <prefix>out</prefix> |
| <sort_size>5000</sort_size> |
| <free_memory/> |
| <compress>N</compress> |
| <compress_variable/> |
| <unique_rows>N</unique_rows> |
| <fields> |
| <field> |
| <name>subnr</name> |
| <ascending>Y</ascending> |
| <case_sensitive>Y</case_sensitive> |
| <collator_enabled>N</collator_enabled> |
| <collator_strength>0</collator_strength> |
| <presorted>N</presorted> |
| </field> |
| </fields> |
| <cluster_schema/> |
| |
| <input> |
| </input> |
| <output> |
| </output> |
| |
| <GUI> |
| <xloc>377</xloc> |
| <yloc>305</yloc> |
| <draw>Y</draw> |
| </GUI> |
| </transform> |
| |
| <transform> |
| <name>subnr</name> |
| <type>ScriptValueMod</type> |
| <description/> |
| <distribute>Y</distribute> |
| <custom_distribution/> |
| <copies>1</copies> |
| <partitioning> |
| <method>none</method> |
| <schema_name/> |
| </partitioning> |
| <compatible>Y</compatible> |
| <optimizationLevel/> |
| <jsScripts> <jsScript> <jsScript_type>0</jsScript_type> |
| <jsScript_name>ScriptValue</jsScript_name> |
| <jsScript_script>
var subnr
var prevId;

if (prevId!=null)
{
 if ( prevId!=id.getInteger() )
 {
 subnr= 1;
 }
 else
 {
 subnr++;
 }
}
else
{
 subnr = 1;
}


prevId = id.getInteger();</jsScript_script> |
| </jsScript> </jsScripts> <fields> <field> <name>subnr</name> |
| <rename>subnr</rename> |
| <type>Integer</type> |
| <length>5</length> |
| <precision>0</precision> |
| <replace>N</replace> |
| </field> </fields> <cluster_schema/> |
| |
| <input> |
| </input> |
| <output> |
| </output> |
| |
| <GUI> |
| <xloc>472</xloc> |
| <yloc>77</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> |
