MERGE ROWS(DIFF) IN PENTAHO

Today, i will discuss about the component “Merge Rows(Diff)” in Pentaho. See the below transformation for the same. Before we start discussion on Merge Rows, always remember to sort the data on common columns from both streams before you add Merge row component. Otherwise results will not be correct. Here , i considered two CSV files which has data of employees. See the below images for the same. Here MAR-SAL.csv is mapped to Reference rows origin field in Merge rows component and FEB-SAL.csv is mapped to Compare rows origin  field in Merge…