Google Git
Sign in
apache / hop / 05dfec1ae4c4de7ce2bd10c7b5b43ee9a80342ea / . / integration-tests / transforms / 0011-calculator-basics.hpl
blob: 38915bffd6bca597e7855b37bc4330db37f0e190 [file] [log] [blame]
<?xml version="1.0" encoding="UTF-8"?>
<!--
Licensed to the Apache Software Foundation (ASF) under one or more
contributor license agreements. See the NOTICE file distributed with
this work for additional information regarding copyright ownership.
The ASF licenses this file to You under the Apache License, Version 2.0
(the "License"); you may not use this file except in compliance with
the License. You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.
-->
<pipeline>
<info>
<name>0011-calculator-basics</name>
<name_sync_with_filename>Y</name_sync_with_filename>
<description/>
<extended_description/>
<pipeline_version/>
<pipeline_type>Normal</pipeline_type>
<parameters>
</parameters>
<capture_transform_performance>N</capture_transform_performance>
<transform_performance_capturing_delay>1000</transform_performance_capturing_delay>
<transform_performance_capturing_size_limit>100</transform_performance_capturing_size_limit>
<created_user>-</created_user>
<created_date>2021/05/07 11:59:55.005</created_date>
<modified_user>-</modified_user>
<modified_date>2021/05/07 11:59:55.005</modified_date>
<key_for_session_key>H4sIAAAAAAAAAAMAAAAAAAAAAAA=</key_for_session_key>
<is_key_private>N</is_key_private>
</info>
<notepads>
</notepads>
<order>
<hop>
<from>test-data</from>
<to>Calculator</to>
<enabled>Y</enabled>
</hop>
<hop>
<from>Calculator</from>
<to>Verify</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>
<failIfNoFile>Y</failIfNoFile>
<calculation>
<calc_type>CONSTANT</calc_type>
<conversion_mask/>
<currency_symbol/>
<decimal_symbol/>
<field_a>static</field_a>
<field_b/>
<field_c/>
<field_name>constStr</field_name>
<grouping_symbol/>
<remove>N</remove>
<value_length>-1</value_length>
<value_precision>-1</value_precision>
<value_type>String</value_type>
</calculation>
<calculation>
<calc_type>CONSTANT</calc_type>
<conversion_mask/>
<currency_symbol/>
<decimal_symbol/>
<field_a>1</field_a>
<field_b/>
<field_c/>
<field_name>constInt</field_name>
<grouping_symbol/>
<remove>N</remove>
<value_length>-1</value_length>
<value_precision>-1</value_precision>
<value_type>Integer</value_type>
</calculation>
<calculation>
<calc_type>CONSTANT</calc_type>
<conversion_mask/>
<currency_symbol/>
<decimal_symbol/>
<field_a> - </field_a>
<field_b/>
<field_c/>
<field_name>ConstSep</field_name>
<grouping_symbol/>
<remove>Y</remove>
<value_length>-1</value_length>
<value_precision>-1</value_precision>
<value_type>String</value_type>
</calculation>
<calculation>
<calc_type>ADD</calc_type>
<conversion_mask/>
<currency_symbol/>
<decimal_symbol/>
<field_a>intA</field_a>
<field_b>intB</field_b>
<field_c/>
<field_name>intAPlusB</field_name>
<grouping_symbol/>
<remove>N</remove>
<value_length>-1</value_length>
<value_precision>-1</value_precision>
<value_type>Integer</value_type>
</calculation>
<calculation>
<calc_type>ADD</calc_type>
<conversion_mask/>
<currency_symbol/>
<decimal_symbol/>
<field_a>numA</field_a>
<field_b>numB</field_b>
<field_c/>
<field_name>numAPlusB</field_name>
<grouping_symbol/>
<remove>N</remove>
<value_length>-1</value_length>
<value_precision>-1</value_precision>
<value_type>Number</value_type>
</calculation>
<calculation>
<calc_type>ADD</calc_type>
<conversion_mask/>
<currency_symbol/>
<decimal_symbol/>
<field_a>strA</field_a>
<field_b>ConstSep</field_b>
<field_c/>
<field_name>strAPlusBTmp</field_name>
<grouping_symbol/>
<remove>Y</remove>
<value_length>-1</value_length>
<value_precision>-1</value_precision>
<value_type>String</value_type>
</calculation>
<calculation>
<calc_type>ADD</calc_type>
<conversion_mask/>
<currency_symbol/>
<decimal_symbol/>
<field_a>strAPlusBTmp</field_a>
<field_b>strB</field_b>
<field_c/>
<field_name>strAPlusB</field_name>
<grouping_symbol/>
<remove>N</remove>
<value_length>-1</value_length>
<value_precision>-1</value_precision>
<value_type>String</value_type>
</calculation>
<calculation>
<calc_type>SUBTRACT</calc_type>
<conversion_mask/>
<currency_symbol/>
<decimal_symbol/>
<field_a>intC</field_a>
<field_b>intB</field_b>
<field_c/>
<field_name>intCMinusB</field_name>
<grouping_symbol/>
<remove>N</remove>
<value_length>-1</value_length>
<value_precision>-1</value_precision>
<value_type>Integer</value_type>
</calculation>
<calculation>
<calc_type>SUBTRACT</calc_type>
<conversion_mask/>
<currency_symbol/>
<decimal_symbol/>
<field_a>numC</field_a>
<field_b>numB</field_b>
<field_c/>
<field_name>numCMinusB</field_name>
<grouping_symbol/>
<remove>N</remove>
<value_length>-1</value_length>
<value_precision>-1</value_precision>
<value_type>Number</value_type>
</calculation>
<calculation>
<calc_type>MULTIPLY</calc_type>
<conversion_mask/>
<currency_symbol/>
<decimal_symbol/>
<field_a>intA</field_a>
<field_b>intB</field_b>
<field_c/>
<field_name>intATimesB</field_name>
<grouping_symbol/>
<remove>N</remove>
<value_length>-1</value_length>
<value_precision>-1</value_precision>
<value_type>Integer</value_type>
</calculation>
<calculation>
<calc_type>MULTIPLY</calc_type>
<conversion_mask/>
<currency_symbol/>
<decimal_symbol/>
<field_a>numA</field_a>
<field_b>numB</field_b>
<field_c/>
<field_name>numATimesB</field_name>
<grouping_symbol/>
<remove>N</remove>
<value_length>-1</value_length>
<value_precision>-1</value_precision>
<value_type>Number</value_type>
</calculation>
<calculation>
<calc_type>DIVIDE</calc_type>
<conversion_mask/>
<currency_symbol/>
<decimal_symbol/>
<field_a>intC</field_a>
<field_b>intA</field_b>
<field_c/>
<field_name>intCDivA</field_name>
<grouping_symbol/>
<remove>N</remove>
<value_length>-1</value_length>
<value_precision>-1</value_precision>
<value_type>Number</value_type>
</calculation>
<calculation>
<calc_type>DIVIDE</calc_type>
<conversion_mask/>
<currency_symbol/>
<decimal_symbol/>
<field_a>numA</field_a>
<field_b>numB</field_b>
<field_c/>
<field_name>numADivB</field_name>
<grouping_symbol/>
<remove>N</remove>
<value_length>-1</value_length>
<value_precision>-1</value_precision>
<value_type>Number</value_type>
</calculation>
<calculation>
<calc_type>SQUARE</calc_type>
<conversion_mask/>
<currency_symbol/>
<decimal_symbol/>
<field_a>intA</field_a>
<field_b>intA</field_b>
<field_c/>
<field_name>intA*A</field_name>
<grouping_symbol/>
<remove>N</remove>
<value_length>-1</value_length>
<value_precision>-1</value_precision>
<value_type>Integer</value_type>
</calculation>
<calculation>
<calc_type>SQUARE</calc_type>
<conversion_mask/>
<currency_symbol/>
<decimal_symbol/>
<field_a>numA</field_a>
<field_b>numA</field_b>
<field_c/>
<field_name>numA*A</field_name>
<grouping_symbol/>
<remove>N</remove>
<value_length>-1</value_length>
<value_precision>-1</value_precision>
<value_type>Number</value_type>
</calculation>
<calculation>
<calc_type>SQUARE_ROOT</calc_type>
<conversion_mask/>
<currency_symbol/>
<decimal_symbol/>
<field_a>intA</field_a>
<field_b/>
<field_c/>
<field_name>intSqrt(a)</field_name>
<grouping_symbol/>
<remove>N</remove>
<value_length>-1</value_length>
<value_precision>-1</value_precision>
<value_type>Integer</value_type>
</calculation>
<calculation>
<calc_type>SQUARE_ROOT</calc_type>
<conversion_mask/>
<currency_symbol/>
<decimal_symbol/>
<field_a>numA</field_a>
<field_b/>
<field_c/>
<field_name>numSqrt(a)</field_name>
<grouping_symbol/>
<remove>N</remove>
<value_length>-1</value_length>
<value_precision>-1</value_precision>
<value_type>Number</value_type>
</calculation>
<calculation>
<calc_type>PERCENT_1</calc_type>
<conversion_mask/>
<currency_symbol/>
<decimal_symbol/>
<field_a>intA</field_a>
<field_b>intB</field_b>
<field_c/>
<field_name>intPctAofB</field_name>
<grouping_symbol/>
<remove>N</remove>
<value_length>-1</value_length>
<value_precision>-1</value_precision>
<value_type>Integer</value_type>
</calculation>
<calculation>
<calc_type>PERCENT_1</calc_type>
<conversion_mask/>
<currency_symbol/>
<decimal_symbol/>
<field_a>numA</field_a>
<field_b>numB</field_b>
<field_c/>
<field_name>numPctAofB</field_name>
<grouping_symbol/>
<remove>N</remove>
<value_length>-1</value_length>
<value_precision>-1</value_precision>
<value_type>Number</value_type>
</calculation>
<calculation>
<calc_type>COPY_FIELD</calc_type>
<conversion_mask/>
<currency_symbol/>
<decimal_symbol/>
<field_a>numA</field_a>
<field_b/>
<field_c/>
<field_name>copyOfNumA</field_name>
<grouping_symbol/>
<remove>N</remove>
<value_length>-1</value_length>
<value_precision>-1</value_precision>
<value_type>Number</value_type>
</calculation>
<attributes/>
<GUI>
<xloc>240</xloc>
<yloc>80</yloc>
</GUI>
</transform>
<transform>
<name>Verify</name>
<type>Dummy</type>
<description/>
<distribute>Y</distribute>
<custom_distribution/>
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name/>
</partitioning>
<attributes/>
<GUI>
<xloc>384</xloc>
<yloc>80</yloc>
</GUI>
</transform>
<transform>
<name>test-data</name>
<type>DataGrid</type>
<description/>
<distribute>Y</distribute>
<custom_distribution/>
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name/>
</partitioning>
<fields>
<field>
<name>intA</name>
<type>Integer</type>
<format/>
<currency/>
<decimal/>
<group/>
<length>-1</length>
<precision>-1</precision>
<set_empty_string>N</set_empty_string>
</field>
<field>
<name>intB</name>
<type>Integer</type>
<format/>
<currency/>
<decimal/>
<group/>
<length>-1</length>
<precision>-1</precision>
<set_empty_string>N</set_empty_string>
</field>
<field>
<name>intC</name>
<type>Integer</type>
<format/>
<currency/>
<decimal/>
<group/>
<length>-1</length>
<precision>-1</precision>
<set_empty_string>N</set_empty_string>
</field>
<field>
<name>numA</name>
<type>Number</type>
<format>#.000;-#.000</format>
<currency/>
<decimal/>
<group/>
<length>7</length>
<precision>3</precision>
<set_empty_string>N</set_empty_string>
</field>
<field>
<name>numB</name>
<type>Number</type>
<format>#.000;-#.000</format>
<currency/>
<decimal/>
<group/>
<length>7</length>
<precision>3</precision>
<set_empty_string>N</set_empty_string>
</field>
<field>
<name>numC</name>
<type>Number</type>
<format>#.000;-#.000</format>
<currency/>
<decimal/>
<group/>
<length>7</length>
<precision>3</precision>
<set_empty_string>N</set_empty_string>
</field>
<field>
<name>strA</name>
<type>String</type>
<format/>
<currency/>
<decimal/>
<group/>
<length>-1</length>
<precision>-1</precision>
<set_empty_string>N</set_empty_string>
</field>
<field>
<name>strB</name>
<type>String</type>
<format/>
<currency/>
<decimal/>
<group/>
<length>-1</length>
<precision>-1</precision>
<set_empty_string>N</set_empty_string>
</field>
</fields>
<data>
<line>
<item>100</item>
<item>200</item>
<item>300</item>
<item>123.456</item>
<item>987.654</item>
<item>99.999</item>
<item>aaa</item>
<item>bbb</item>
</line>
</data>
<attributes/>
<GUI>
<xloc>96</xloc>
<yloc>80</yloc>
</GUI>
</transform>
<transform_error_handling>
</transform_error_handling>
<attributes/>
</pipeline>