Pentaho merge rows (diff) not showing "changed"
I've got this steps
The merge rows diff is configured as follow
But when a update is detected it doesn't show the "changed" tag, it show two rows, a deleted and a new
The documentation says that a "changed" tag should be displayed on the update case. Could anybody help me on this?
I've try with the sort by id steps, and I currently have a SORT BY id on the table imput query. But nothing seems to work.
Solution
Well, a friend saw the problem. The key fields and the value fields definition was all wrong. This is the right way to configure the merge row (diff) step:
The `Get value fields' button confuses me. Now I've got the right result
- How to configure Pentaho Carte to accept HTTPS request instead of HTTP
- Pentaho/POI throws InvocationTargetException
- Git Not In Sync with Local Branch
- "RecursionError: maximum recursion depth exceeded" from ssl.py: `super(SSLContext, SSLContext).options.__set__(self, value)`
- How do I clear the cache in Pentaho Data Integration
- What is the difference between data integration softwares and ESB?
- Create a near real time DWH with Pentaho Community edition
- Set the charset for Firebird connection from Pentaho DI
- Pentaho Data Integration Community Edition 9.4 - Shared objects file feature of transformation doesn't support variable
- Pentaho Data Integration 9.3 - Postgres Incremental load
- How to find unique values from set of rows using pentaho kettle?
- How to add zero in front of single digit values using REGEX in pentaho
- Pentaho File Repository Moves Jobs & Transformations to root
- Use a field from a previous hop as a parameter in a Table input using Pentaho Kettle
- Pentaho kettle Can't run transformation due to plugin missing
- Waiting for Transformations in a Job
- Pentaho CDE: Is there a way to debug the sql command being executed?
- Pentaho Kettle replace cell value if value exists in other two columns
- How to find where KETTLE HOME is defined
- REST API calls through Pentaho Data Integration (Spoon)
- Pentaho PDI || Windows Current User
- Pentaho check if at least one row LDAP is 0
- Get row number from stream to perform concat
- How input data in line chart in Pentaho?
- Pentaho-carte rest api?
- How to run Pentaho transformations in parallel and limit executors count
- Pentaho to kill all running transformations if any one them fails
- Pentaho Business Inteligence Automation
- How to delete rows which were deleted in source table (Pentaho data integration)
- Connection between pentaho and mysql is reset