update to zero if doesnt have purchase price

1 files changed, 511 insertions, 11 deletions

diff --git a/calculate_price_after_disc.ktr b/calculate_price_after_disc.ktr
index 4a60dab..d96c01e 100644
--- a/calculate_price_after_disc.ktr
+++ b/calculate_price_after_disc.ktr
@@ -519,7 +519,12 @@
     </hop>
     <hop>
       <from>Filter rows</from>
-      <to>Write to log</to>
+      <to>Add constants</to>
+      <enabled>Y</enabled>
+    </hop>
+    <hop>
+      <from>Add constants</from>
+      <to>Insert / update 2</to>
       <enabled>Y</enabled>
     </hop>
   </order>
@@ -3212,7 +3217,7 @@ left join brand b on b.id = p.brand_id</sql>
       <schema_name/>
     </partitioning>
     <send_true_to>calculate price after disc</send_true_to>
-    <send_false_to>Write to log</send_false_to>
+    <send_false_to>Add constants</send_false_to>
     <compare>
       <condition>
         <negated>N</negated>
@@ -3245,8 +3250,8 @@ left join brand b on b.id = p.brand_id</sql>
     </GUI>
   </step>
   <step>
-    <name>Write to log</name>
-    <type>WriteToLog</type>
+    <name>Add constants</name>
+    <type>Constant</type>
     <description/>
     <distribute>Y</distribute>
     <custom_distribution/>
@@ -3255,13 +3260,20 @@ left join brand b on b.id = p.brand_id</sql>
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <loglevel>log_level_basic</loglevel>
-    <displayHeader>Y</displayHeader>
-    <limitRows>N</limitRows>
-    <limitRowsNumber>0</limitRowsNumber>
-    <logmessage/>
     <fields>
-      </fields>
+      <field>
+        <name>zero</name>
+        <type>Number</type>
+        <format/>
+        <currency/>
+        <decimal/>
+        <group/>
+        <nullif>0</nullif>
+        <length>-1</length>
+        <precision>-1</precision>
+        <set_empty_string>N</set_empty_string>
+      </field>
+    </fields>
     <attributes/>
     <cluster_schema/>
     <remotesteps>
@@ -3271,11 +3283,499 @@ left join brand b on b.id = p.brand_id</sql>
       </output>
     </remotesteps>
     <GUI>
-      <xloc>176</xloc>
+      <xloc>240</xloc>
       <yloc>192</yloc>
       <draw>Y</draw>
     </GUI>
   </step>
+  <step>
+    <name>Insert / update 2</name>
+    <type>InsertUpdate</type>
+    <description/>
+    <distribute>Y</distribute>
+    <custom_distribution/>
+    <copies>1</copies>
+    <partitioning>
+      <method>none</method>
+      <schema_name/>
+    </partitioning>
+    <connection>dw bi indoteknik</connection>
+    <commit>100</commit>
+    <update_bypassed>N</update_bypassed>
+    <lookup>
+      <schema>public</schema>
+      <table>pricelist_compute</table>
+      <key>
+        <name>product_id</name>
+        <field>product_id</field>
+        <condition>=</condition>
+        <name2/>
+      </key>
+      <value>
+        <name>product_id</name>
+        <rename>product_id</rename>
+        <update>N</update>
+      </value>
+      <value>
+        <name>item_code</name>
+        <rename>item_code</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>name</name>
+        <rename>name</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>pricing_group</name>
+        <rename>pricing_group</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>purchase_price</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_std1</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_std2</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_std3</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_std4</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_std5</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_group1</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_group2</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_group3</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_group4</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_group5</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_tier2_1</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_tier2_2</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_tier2_3</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_tier2_4</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_tier2_5</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_tier3_1</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_tier3_2</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_tier3_3</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_tier3_4</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_tier3_5</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_tier4_1</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_tier4_2</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_tier4_3</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_tier4_4</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_tier4_5</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_tier5_1</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_tier5_2</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_tier5_3</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_tier5_4</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>markup_tier5_5</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_after_disc_1</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_after_disc_2</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_after_disc_3</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_after_disc_4</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_after_disc_5</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_before_disc1</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_before_disc2</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_before_disc3</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_before_disc4</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_before_disc5</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_tier2_1</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_tier2_2</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_tier2_3</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_tier2_4</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_tier2_5</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_tier3_1</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_tier3_2</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_tier3_3</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_tier3_4</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_tier3_5</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_tier4_1</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_tier4_2</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_tier4_3</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_tier4_4</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_tier4_5</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_tier5_1</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_tier5_2</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_tier5_3</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_tier5_4</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>price_tier5_5</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>disc1_1</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>disc1_2</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>disc1_3</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>disc1_4</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>disc1_5</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>disc2_1</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>disc2_2</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>disc2_3</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>disc2_4</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>disc2_5</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>disc3_1</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>disc3_2</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>disc3_3</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>disc3_4</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>disc3_5</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>disc4_1</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>disc4_2</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>disc4_3</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>disc4_4</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>disc4_5</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>disc5_1</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>disc5_2</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>disc5_3</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>disc5_4</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>disc5_5</name>
+        <rename>zero</rename>
+        <update>Y</update>
+      </value>
+    </lookup>
+    <attributes/>
+    <cluster_schema/>
+    <remotesteps>
+      <input>
+      </input>
+      <output>
+      </output>
+    </remotesteps>
+    <GUI>
+      <xloc>240</xloc>
+      <yloc>304</yloc>
+      <draw>Y</draw>
+    </GUI>
+  </step>
   <step_error_handling>
   </step_error_handling>
   <slave-step-copy-partition-distribution>