在pentaho Data Integration中，根据其他输入行的字段值更新一行中的字段值 [英] In pentaho Data Integration, update field value in a row, depending on field values of other input rows

问题描述

我创建了一个转换，其中经过几步后生成行.现在作为下一步，我想根据其他行的值计算每一行的字段值(这是自定义逻辑，因此必须一次性访问所有行).

I have created one transformation in which rows are generated after several step. Now as a next step, I want to calculate field value for each row based on values of other rows (it is custom logic, so necessary to have access at all rows at one shot).

我考虑使用 javascript 步骤.在这一步中，我可以访问当前行的字段值，但如何访问其他行的值.同样的方式，我检查了用户定义的 Java 类步骤，但停留在如何访问除当前行值之外的其他行值的步骤.

I considered to use javascript step. In this step, I can access field values of current row but how to access values for other rows. Same way, I checked with User Defined Java Class step, but stuck at the step where how to access other rows value apart from current one.

推荐答案

使用 Group by step 计算行.它有很多选项，例如 SUM、Average、Max、Min、第一个非空值、Cumulative sum(仅限所有行选项！)、累积平均值(仅限所有行选项！)等

Use Group by step to calculated rows. It has a lot of options such as SUM, Average, Max, Min, First non-null value, Cumulative sum (all rows option only!) , Cumulative average (all rows option only!), etc

这篇关于在pentaho Data Integration中，根据其他输入行的字段值更新一行中的字段值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！