合并行(差异)是逐行比较，而不是将一行与其他表的整行进行比较 [英] Merge Rows (diff) is comparing row by row, not one row to entire rows of other table

问题描述

我正在使用合并行(差异)比较两张工作表.

I am comparing two sheets using Merge Rows (diff).

第一个 Excel 表:

1st excel sheet:

第二张 Excel 表格:

2nd excel sheet:

和我的 pentaho 交易:

and my pentaho transaction:

在预览数据显示中，第2行的id 2.0是添加新行，第4行显示相同的数据是删除，假设相同，那么如何实现.

in preview data showing, that id 2.0 at 2nd row is add new row and at 4 row its showing same data is delete, its suppose to identical, so how it can be achieve.

推荐答案

合并行 (diff) 要求两个输入流都按合并键排序(编辑步骤的属性时会出现警告).

Merge rows (diff) requires both input streams to be sorted by the merge keys (there's a warning about it when you edit the step's properties).

在合并行(差异)步骤之前在每个流中放置一个排序行步骤.

Put a sort rows step in each stream ahead of the Merge Rows (diff) step.

这篇关于合并行(差异)是逐行比较，而不是将一行与其他表的整行进行比较的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！