diff options
| author | stephanchrst <stephanchrst@gmail.com> | 2023-10-31 10:46:37 +0700 |
|---|---|---|
| committer | stephanchrst <stephanchrst@gmail.com> | 2023-10-31 10:46:37 +0700 |
| commit | d10eefdef28cb70addbd8bba8fff50b0341065ff (patch) | |
| tree | 637ae05ea2d70ce1142b9a0755fa8faf3d75e677 /import_adempiere_to_data_warehouse.ktr | |
| parent | 9355f83e246314b903c3ae794655fde39b938ca0 (diff) | |
fix error adempiere
Diffstat (limited to 'import_adempiere_to_data_warehouse.ktr')
| -rw-r--r-- | import_adempiere_to_data_warehouse.ktr | 212 |
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> |
