Google Git
Sign in
apache / hop / 897e18786836171c3239e29f90151c786180dcb6 / . / archive-samples / transformations / Group by - include all rows and calculations .ktr
blob: 21360c325a30f4c1707a3cbad4443830837f2264 [file] [log] [blame]
<?xml version="1.0" encoding="UTF-8"?>
<pipeline>
<info>
<name>Group by - include all rows and calculations </name>
<description/>
<extended_description/>
<trans_version/>
<trans_type>Normal</trans_type>
<directory>&#x2f;</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>350</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&#x2f;03&#x2f;03 20&#x3a;39&#x3a;03.386</created_date>
<modified_user/>
<modified_date>2014&#x2f;03&#x2f;03 20&#x3a;39&#x3a;03.386</modified_date>
<key_for_session_key>H4sIAAAAAAAAAAMAAAAAAAAAAAA&#x3d;</key_for_session_key>
<is_key_private>N</is_key_private>
</info>
<notepads>
<notepad>
<note>To see the result, do a preview on this Dummy transform&#xa;... or add an output transform.</note>
<xloc>173</xloc>
<yloc>516</yloc>
<width>320</width>
<heigth>42</heigth>
<fontname/>
<fontsize>-1</fontsize>
<fontbold>N</fontbold>
<fontitalic>N</fontitalic>
<fontcolorred>0</fontcolorred>
<fontcolorgreen>0</fontcolorgreen>
<fontcolorblue>0</fontcolorblue>
<backgroundcolorred>255</backgroundcolorred>
<backgroundcolorgreen>205</backgroundcolorgreen>
<backgroundcolorblue>112</backgroundcolorblue>
<bordercolorred>100</bordercolorred>
<bordercolorgreen>100</bordercolorgreen>
<bordercolorblue>100</bordercolorblue>
<drawshadow>N</drawshadow>
</notepad>
<notepad>
<note>Load the example fixed length textfile.</note>
<xloc>36</xloc>
<yloc>28</yloc>
<width>241</width>
<heigth>26</heigth>
<fontname/>
<fontsize>-1</fontsize>
<fontbold>N</fontbold>
<fontitalic>N</fontitalic>
<fontcolorred>0</fontcolorred>
<fontcolorgreen>0</fontcolorgreen>
<fontcolorblue>0</fontcolorblue>
<backgroundcolorred>255</backgroundcolorred>
<backgroundcolorgreen>205</backgroundcolorgreen>
<backgroundcolorblue>112</backgroundcolorblue>
<bordercolorred>100</bordercolorred>
<bordercolorgreen>100</bordercolorgreen>
<bordercolorblue>100</bordercolorblue>
<drawshadow>N</drawshadow>
</notepad>
<notepad>
<note>Revision notes&#x3a;&#xa;2006-08-07 Jens Bleuel&#x3a; created&#xa;2006-09-08 Matt Casters&#x3a; revised to use Internal variables to point to input file</note>
<xloc>27</xloc>
<yloc>625</yloc>
<width>492</width>
<heigth>58</heigth>
<fontname/>
<fontsize>-1</fontsize>
<fontbold>N</fontbold>
<fontitalic>N</fontitalic>
<fontcolorred>0</fontcolorred>
<fontcolorgreen>0</fontcolorgreen>
<fontcolorblue>0</fontcolorblue>
<backgroundcolorred>255</backgroundcolorred>
<backgroundcolorgreen>205</backgroundcolorgreen>
<backgroundcolorblue>112</backgroundcolorblue>
<bordercolorred>100</bordercolorred>
<bordercolorgreen>100</bordercolorgreen>
<bordercolorblue>100</bordercolorblue>
<drawshadow>N</drawshadow>
</notepad>
<notepad>
<note>Sort rows by Gender for the following group by</note>
<xloc>168</xloc>
<yloc>165</yloc>
<width>294</width>
<heigth>26</heigth>
<fontname/>
<fontsize>-1</fontsize>
<fontbold>N</fontbold>
<fontitalic>N</fontitalic>
<fontcolorred>0</fontcolorred>
<fontcolorgreen>0</fontcolorgreen>
<fontcolorblue>0</fontcolorblue>
<backgroundcolorred>255</backgroundcolorred>
<backgroundcolorgreen>205</backgroundcolorgreen>
<backgroundcolorblue>112</backgroundcolorblue>
<bordercolorred>100</bordercolorred>
<bordercolorgreen>100</bordercolorgreen>
<bordercolorblue>100</bordercolorblue>
<drawshadow>N</drawshadow>
</notepad>
<notepad>
<note>Group and aggregate rows &#xa;&#x28;include all rows is checked&#x29;</note>
<xloc>172</xloc>
<yloc>246</yloc>
<width>181</width>
<heigth>42</heigth>
<fontname/>
<fontsize>-1</fontsize>
<fontbold>N</fontbold>
<fontitalic>N</fontitalic>
<fontcolorred>0</fontcolorred>
<fontcolorgreen>0</fontcolorgreen>
<fontcolorblue>0</fontcolorblue>
<backgroundcolorred>255</backgroundcolorred>
<backgroundcolorgreen>205</backgroundcolorgreen>
<backgroundcolorblue>112</backgroundcolorblue>
<bordercolorred>100</bordercolorred>
<bordercolorgreen>100</bordercolorgreen>
<bordercolorblue>100</bordercolorblue>
<drawshadow>N</drawshadow>
</notepad>
<notepad>
<note>Count the rows</note>
<xloc>173</xloc>
<yloc>344</yloc>
<width>102</width>
<heigth>26</heigth>
<fontname/>
<fontsize>-1</fontsize>
<fontbold>N</fontbold>
<fontitalic>N</fontitalic>
<fontcolorred>0</fontcolorred>
<fontcolorgreen>0</fontcolorgreen>
<fontcolorblue>0</fontcolorblue>
<backgroundcolorred>255</backgroundcolorred>
<backgroundcolorgreen>205</backgroundcolorgreen>
<backgroundcolorblue>112</backgroundcolorblue>
<bordercolorred>100</bordercolorred>
<bordercolorgreen>100</bordercolorgreen>
<bordercolorblue>100</bordercolorblue>
<drawshadow>N</drawshadow>
</notepad>
<notepad>
<note>Calculate the average Internet usage in hours per week and&#xa;the percentage of students knowing about Internet.</note>
<xloc>175</xloc>
<yloc>422</yloc>
<width>370</width>
<heigth>42</heigth>
<fontname/>
<fontsize>-1</fontsize>
<fontbold>N</fontbold>
<fontitalic>N</fontitalic>
<fontcolorred>0</fontcolorred>
<fontcolorgreen>0</fontcolorgreen>
<fontcolorblue>0</fontcolorblue>
<backgroundcolorred>255</backgroundcolorred>
<backgroundcolorgreen>205</backgroundcolorgreen>
<backgroundcolorblue>112</backgroundcolorblue>
<bordercolorred>100</bordercolorred>
<bordercolorgreen>100</bordercolorgreen>
<bordercolorblue>100</bordercolorblue>
<drawshadow>N</drawshadow>
</notepad>
</notepads>
<order>
<hop>
<from>Sort rows</from>
<to>Group by - Sums</to>
<enabled>Y</enabled>
</hop>
<hop>
<from>Text file input</from>
<to>Sort rows</to>
<enabled>Y</enabled>
</hop>
<hop>
<from>Group by - Sums</from>
<to>Group by - rowcount</to>
<enabled>Y</enabled>
</hop>
<hop>
<from>Group by - rowcount</from>
<to>Calculator</to>
<enabled>Y</enabled>
</hop>
<hop>
<from>Calculator</from>
<to>Dummy &#x28;do nothing&#x29;</to>
<enabled>Y</enabled>
</hop>
</order>
<transform>
<name>Calculator</name>
<type>Calculator</type>
<description/>
<distribute>Y</distribute>
<custom_distribution/>
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name/>
</partitioning>
<calculation>
<field_name>InternetIsKnownPercentage</field_name>
<calc_type>PERCENT_1</calc_type>
<field_a>InternetIsKnownSum</field_a>
<field_b>NumberOfInterviews</field_b>
<field_c/>
<value_type>None</value_type>
<value_length>-1</value_length>
<value_precision>-1</value_precision>
<remove>N</remove>
<conversion_mask/>
<decimal_symbol/>
<grouping_symbol/>
<currency_symbol/>
</calculation>
<calculation>
<field_name>AverageInternetUsageHoursPerWeek</field_name>
<calc_type>DIVIDE</calc_type>
<field_a>InternetUsagePerWeekSum</field_a>
<field_b>InternetIsKnownSum</field_b>
<field_c/>
<value_type>None</value_type>
<value_length>-1</value_length>
<value_precision>-1</value_precision>
<remove>N</remove>
<conversion_mask/>
<decimal_symbol/>
<grouping_symbol/>
<currency_symbol/>
</calculation>
<cluster_schema/>
<input>
</input>
<output>
</output>
<GUI>
<xloc>107</xloc>
<yloc>430</yloc>
<draw>Y</draw>
</GUI>
</transform>
<transform>
<name>Dummy &#x28;do nothing&#x29;</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>107</xloc>
<yloc>528</yloc>
<draw>Y</draw>
</GUI>
</transform>
<transform>
<name>Group by - Sums</name>
<type>GroupBy</type>
<description/>
<distribute>Y</distribute>
<custom_distribution/>
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name/>
</partitioning>
<all_rows>Y</all_rows>
<ignore_aggregate>N</ignore_aggregate>
<field_ignore/>
<directory>&#x25;&#x25;java.io.tmpdir&#x25;&#x25;</directory>
<prefix>grp</prefix>
<add_linenr>N</add_linenr>
<linenr_fieldname/>
<give_back_row>N</give_back_row>
<group>
<field>
<name>Gender</name>
</field>
</group>
<fields>
<field>
<aggregate>InternetIsKnownSum</aggregate>
<subject>InternetIsKnown</subject>
<type>SUM</type>
<valuefield/>
</field>
<field>
<aggregate>InternetUsagePerWeekSum</aggregate>
<subject>InternetUsagePerWeek</subject>
<type>SUM</type>
<valuefield/>
</field>
</fields>
<cluster_schema/>
<input>
</input>
<output>
</output>
<GUI>
<xloc>104</xloc>
<yloc>254</yloc>
<draw>Y</draw>
</GUI>
</transform>
<transform>
<name>Group by - rowcount</name>
<type>GroupBy</type>
<description/>
<distribute>Y</distribute>
<custom_distribution/>
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name/>
</partitioning>
<all_rows>N</all_rows>
<ignore_aggregate>N</ignore_aggregate>
<field_ignore/>
<directory>&#x25;&#x25;java.io.tmpdir&#x25;&#x25;</directory>
<prefix>grp</prefix>
<add_linenr>N</add_linenr>
<linenr_fieldname/>
<give_back_row>Y</give_back_row>
<group>
<field>
<name>Gender</name>
</field>
<field>
<name>InternetIsKnownSum</name>
</field>
<field>
<name>InternetUsagePerWeekSum</name>
</field>
</group>
<fields>
<field>
<aggregate>NumberOfInterviews</aggregate>
<subject>InternetIsKnownSum</subject>
<type>COUNT_ALL</type>
<valuefield/>
</field>
</fields>
<cluster_schema/>
<input>
</input>
<output>
</output>
<GUI>
<xloc>105</xloc>
<yloc>349</yloc>
<draw>Y</draw>
</GUI>
</transform>
<transform>
<name>Sort rows</name>
<type>SortRows</type>
<description/>
<distribute>Y</distribute>
<custom_distribution/>
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name/>
</partitioning>
<directory>&#x25;&#x25;java.io.tmpdir&#x25;&#x25;</directory>
<prefix>out</prefix>
<sort_size>5000</sort_size>
<free_memory/>
<compress>N</compress>
<compress_variable/>
<unique_rows>N</unique_rows>
<fields>
<field>
<name>Gender</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>104</xloc>
<yloc>165</yloc>
<draw>Y</draw>
</GUI>
</transform>
<transform>
<name>Text file input</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>filenameTXT</accept_field>
<accept_transformname/>
<separator>&#x3b;</separator>
<enclosure>&#x22;</enclosure>
<enclosure_breaks>N</enclosure_breaks>
<escapechar/>
<header>N</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>N</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>&#x24;&#x7b;Internal.Transformation.Filename.Directory&#x7d;&#x2f;files&#x2f;Textfile input - fixed length sample data.txt</name>
<filemask/>
<exclude_filemask/>
<file_required>N</file_required>
<include_subfolders>N</include_subfolders>
<type>Fixed</type>
<compression>None</compression>
</file>
<filters>
</filters>
<fields>
<field>
<name>NotUsed</name>
<type>String</type>
<format/>
<currency/>
<decimal/>
<group/>
<nullif/>
<ifnull/>
<position>0</position>
<length>1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
<repeat>N</repeat>
</field>
<field>
<name>InternetIsKnown</name>
<type>String</type>
<format/>
<currency/>
<decimal/>
<group/>
<nullif/>
<ifnull/>
<position>1</position>
<length>1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
<repeat>N</repeat>
</field>
<field>
<name>CompuServeIsKnown</name>
<type>String</type>
<format/>
<currency/>
<decimal/>
<group/>
<nullif/>
<ifnull/>
<position>2</position>
<length>1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
<repeat>N</repeat>
</field>
<field>
<name>BTXIsKnown</name>
<type>String</type>
<format/>
<currency/>
<decimal/>
<group/>
<nullif/>
<ifnull/>
<position>3</position>
<length>1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
<repeat>N</repeat>
</field>
<field>
<name>JoguBitsIsKnown</name>
<type>String</type>
<format/>
<currency/>
<decimal/>
<group/>
<nullif/>
<ifnull/>
<position>4</position>
<length>1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
<repeat>N</repeat>
</field>
<field>
<name>InternetUsagePerWeek</name>
<type>Number</type>
<format/>
<currency/>
<decimal>.</decimal>
<group/>
<nullif/>
<ifnull/>
<position>5</position>
<length>3</length>
<precision>-1</precision>
<trim_type>both</trim_type>
<repeat>N</repeat>
</field>
<field>
<name>CompuServeUsagePerWeek</name>
<type>Number</type>
<format/>
<currency/>
<decimal>.</decimal>
<group/>
<nullif/>
<ifnull/>
<position>8</position>
<length>3</length>
<precision>-1</precision>
<trim_type>both</trim_type>
<repeat>N</repeat>
</field>
<field>
<name>BTXUsagePerWeek</name>
<type>Number</type>
<format/>
<currency/>
<decimal>.</decimal>
<group/>
<nullif/>
<ifnull/>
<position>11</position>
<length>3</length>
<precision>-1</precision>
<trim_type>both</trim_type>
<repeat>N</repeat>
</field>
<field>
<name>JoguBitsReading</name>
<type>String</type>
<format/>
<currency/>
<decimal/>
<group/>
<nullif/>
<ifnull/>
<position>14</position>
<length>1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
<repeat>N</repeat>
</field>
<field>
<name>Status</name>
<type>String</type>
<format/>
<currency/>
<decimal/>
<group/>
<nullif/>
<ifnull/>
<position>15</position>
<length>1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
<repeat>N</repeat>
</field>
<field>
<name>Faculty</name>
<type>String</type>
<format/>
<currency/>
<decimal/>
<group/>
<nullif/>
<ifnull/>
<position>16</position>
<length>2</length>
<precision>-1</precision>
<trim_type>none</trim_type>
<repeat>N</repeat>
</field>
<field>
<name>Semester</name>
<type>Number</type>
<format/>
<currency/>
<decimal/>
<group/>
<nullif/>
<ifnull/>
<position>18</position>
<length>2</length>
<precision>-1</precision>
<trim_type>both</trim_type>
<repeat>N</repeat>
</field>
<field>
<name>Age</name>
<type>Number</type>
<format/>
<currency/>
<decimal/>
<group/>
<nullif/>
<ifnull/>
<position>20</position>
<length>2</length>
<precision>-1</precision>
<trim_type>both</trim_type>
<repeat>N</repeat>
</field>
<field>
<name>Gender</name>
<type>String</type>
<format/>
<currency/>
<decimal/>
<group/>
<nullif/>
<ifnull/>
<position>22</position>
<length>1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
<repeat>N</repeat>
</field>
<field>
<name>Question1</name>
<type>String</type>
<format/>
<currency/>
<decimal/>
<group/>
<nullif/>
<ifnull/>
<position>23</position>
<length>1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
<repeat>N</repeat>
</field>
<field>
<name>Question2</name>
<type>String</type>
<format/>
<currency/>
<decimal/>
<group/>
<nullif/>
<ifnull/>
<position>24</position>
<length>2</length>
<precision>-1</precision>
<trim_type>none</trim_type>
<repeat>N</repeat>
</field>
<field>
<name>Reserved</name>
<type>String</type>
<format/>
<currency/>
<decimal/>
<group/>
<nullif/>
<ifnull/>
<position>26</position>
<length>4</length>
<precision>-1</precision>
<trim_type>none</trim_type>
<repeat>N</repeat>
</field>
<field>
<name>Remarks</name>
<type>String</type>
<format/>
<currency/>
<decimal/>
<group/>
<nullif/>
<ifnull/>
<position>30</position>
<length>32</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>de_DE</date_format_locale>
<shortFileFieldName/>
<pathFieldName/>
<hiddenFieldName/>
<lastModificationTimeFieldName/>
<uriNameFieldName/>
<rootUriNameFieldName/>
<extensionFieldName/>
<sizeFieldName/>
<cluster_schema/>
<input>
</input>
<output>
</output>
<GUI>
<xloc>103</xloc>
<yloc>81</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>