Différences

Ci-dessous, les différences entre deux révisions de la page.

--- dse:data_query_calcultion [2022/12/21 09:34] – [Map transformation of a list] nicoanto
+++ dse:data_query_calcultion [2022/12/21 09:39] (Version actuelle) – nicoanto
@@ Ligne 2: / Ligne 2: @@
 ===== Map transformation of a list  =====
+The generate is configured as follow :
+  * Generator strategy : Iterate Over List Strategy
+  * List Expression :
 <code>
 [
@@ Ligne 36: / Ligne 38: @@
 {matiere:"Zinc", min:0.95, max:1, average:1}
 ]
+</code>
+The generator pushes into variable : yield_ratio_list
+In a 'Map' component, the @yield_ratio_list variable is transformed as a map variable :
+<code>
+/* Map yield ratio threshold data */
+yield_ratio_threshold: Map<String, Tuple<matiere: String, min: Float, max: Float, average: Float>> = @yield_ratio_list.toMap(keyFunction: x => x.matiere, valueFunction: x => x);
 </code>
+This new map variable is used the following way :
+<code>
+{
+	part:input.part
+	, final_material_weight_net: evaluated_net_weight
+	, final_material_weight_net_source :input.final_material_weight_net_source
+	, final_material_weight_gross: evaluated_net_weight IS NULL
+		? evaluated_gross_weight
+		: yield_ratio>=yield_ratio_threshold[input.rm_name].min AND yield_ratio<=yield_ratio_threshold[input.rm_name].max
+			? evaluated_gross_weight
+			: evaluated_net_weight / yield_ratio_threshold[input.rm_name].average
+}
+</code>