summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorstephanchrst <stephanchrst@gmail.com>2023-10-31 10:46:37 +0700
committerstephanchrst <stephanchrst@gmail.com>2023-10-31 10:46:37 +0700
commitd10eefdef28cb70addbd8bba8fff50b0341065ff (patch)
tree637ae05ea2d70ce1142b9a0755fa8faf3d75e677
parent9355f83e246314b903c3ae794655fde39b938ca0 (diff)
fix error adempiere
-rw-r--r--import_adempiere_to_data_warehouse.ktr212
1 files changed, 106 insertions, 106 deletions
diff --git a/import_adempiere_to_data_warehouse.ktr b/import_adempiere_to_data_warehouse.ktr
index dc913d7..8a444a3 100644
--- a/import_adempiere_to_data_warehouse.ktr
+++ b/import_adempiere_to_data_warehouse.ktr
@@ -625,6 +625,80 @@
</hop>
</order>
<step>
+ <name>Add constants</name>
+ <type>Constant</type>
+ <description/>
+ <distribute>Y</distribute>
+ <custom_distribution/>
+ <copies>1</copies>
+ <partitioning>
+ <method>none</method>
+ <schema_name/>
+ </partitioning>
+ <fields>
+ <field>
+ <name>const_sales</name>
+ <type>String</type>
+ <format/>
+ <currency/>
+ <decimal/>
+ <group/>
+ <nullif>SALES INDUSTRI</nullif>
+ <length>-1</length>
+ <precision>-1</precision>
+ <set_empty_string>N</set_empty_string>
+ </field>
+ </fields>
+ <attributes/>
+ <cluster_schema/>
+ <remotesteps>
+ <input>
+ </input>
+ <output>
+ </output>
+ </remotesteps>
+ <GUI>
+ <xloc>416</xloc>
+ <yloc>16</yloc>
+ <draw>Y</draw>
+ </GUI>
+ </step>
+ <step>
+ <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>data trx adem</send_true_to>
+ <send_false_to>Write to log</send_false_to>
+ <compare>
+ <condition>
+ <negated>N</negated>
+ <leftvalue>salesperson</leftvalue>
+ <function>=</function>
+ <rightvalue>const_sales</rightvalue>
+ </condition>
+ </compare>
+ <attributes/>
+ <cluster_schema/>
+ <remotesteps>
+ <input>
+ </input>
+ <output>
+ </output>
+ </remotesteps>
+ <GUI>
+ <xloc>544</xloc>
+ <yloc>16</yloc>
+ <draw>Y</draw>
+ </GUI>
+ </step>
+ <step>
<name>Merge join</name>
<type>MergeJoin</type>
<description/>
@@ -1640,6 +1714,38 @@ where reference_number is not null</sql>
</GUI>
</step>
<step>
+ <name>Write to log</name>
+ <type>WriteToLog</type>
+ <description/>
+ <distribute>Y</distribute>
+ <custom_distribution/>
+ <copies>1</copies>
+ <partitioning>
+ <method>none</method>
+ <schema_name/>
+ </partitioning>
+ <loglevel>log_level_basic</loglevel>
+ <displayHeader>Y</displayHeader>
+ <limitRows>N</limitRows>
+ <limitRowsNumber>0</limitRowsNumber>
+ <logmessage/>
+ <fields>
+ </fields>
+ <attributes/>
+ <cluster_schema/>
+ <remotesteps>
+ <input>
+ </input>
+ <output>
+ </output>
+ </remotesteps>
+ <GUI>
+ <xloc>656</xloc>
+ <yloc>16</yloc>
+ <draw>Y</draw>
+ </GUI>
+ </step>
+ <step>
<name>adem</name>
<type>SortRows</type>
<description/>
@@ -2105,112 +2211,6 @@ where reference_number is not null</sql>
<draw>Y</draw>
</GUI>
</step>
- <step>
- <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>data trx adem</send_true_to>
- <send_false_to>Write to log</send_false_to>
- <compare>
- <condition>
- <negated>N</negated>
- <leftvalue>salesperson</leftvalue>
- <function>=</function>
- <rightvalue>const_sales</rightvalue>
- </condition>
- </compare>
- <attributes/>
- <cluster_schema/>
- <remotesteps>
- <input>
- </input>
- <output>
- </output>
- </remotesteps>
- <GUI>
- <xloc>544</xloc>
- <yloc>16</yloc>
- <draw>Y</draw>
- </GUI>
- </step>
- <step>
- <name>Add constants</name>
- <type>Constant</type>
- <description/>
- <distribute>Y</distribute>
- <custom_distribution/>
- <copies>1</copies>
- <partitioning>
- <method>none</method>
- <schema_name/>
- </partitioning>
- <fields>
- <field>
- <name>const_sales</name>
- <type/>
- <format/>
- <currency/>
- <decimal/>
- <group/>
- <nullif>SALES INDUSTRI</nullif>
- <length>-1</length>
- <precision>-1</precision>
- <set_empty_string>N</set_empty_string>
- </field>
- </fields>
- <attributes/>
- <cluster_schema/>
- <remotesteps>
- <input>
- </input>
- <output>
- </output>
- </remotesteps>
- <GUI>
- <xloc>416</xloc>
- <yloc>16</yloc>
- <draw>Y</draw>
- </GUI>
- </step>
- <step>
- <name>Write to log</name>
- <type>WriteToLog</type>
- <description/>
- <distribute>Y</distribute>
- <custom_distribution/>
- <copies>1</copies>
- <partitioning>
- <method>none</method>
- <schema_name/>
- </partitioning>
- <loglevel>log_level_basic</loglevel>
- <displayHeader>Y</displayHeader>
- <limitRows>N</limitRows>
- <limitRowsNumber>0</limitRowsNumber>
- <logmessage/>
- <fields>
- </fields>
- <attributes/>
- <cluster_schema/>
- <remotesteps>
- <input>
- </input>
- <output>
- </output>
- </remotesteps>
- <GUI>
- <xloc>656</xloc>
- <yloc>16</yloc>
- <draw>Y</draw>
- </GUI>
- </step>
<step_error_handling>
</step_error_handling>
<slave-step-copy-partition-distribution>