What is the difference between add path and update path in find changes shape?
"The Find Changes shape parses each line at a time and forwards the result down the appropriate path. The first execution of a process with this shape sends all results down the Add path. Subsequent executions use this first document as the basis for comparison, and added or updated data is stored per execution." The documents will go through the ADD path when new rows/docs are added. The documents go through the UPDATE path when an existing row/document(after the first pass) is updated.
Thank you for your reply,
Can you please differentiate "add" and "update path" clearly.
A late reply to this question, but maybe for the benefit of others...
The differences between the paths from a Find Changes shape are best explained by example. Consider an input document with a simple profile with two elements, Id and Code. This profile is used in the Find Changes shape, and the Id is selected as the Key Column.
The Find Changes shape processes a single document containing three records. This results in three separate documents, each following the 'Add' path:
Id, Code11, AAAA -> 'Add' path22, BBBB -> 'Add' path33, CCCC -> 'Add' path
The input document for the subsequent execution contains four records; these are compared to those in the previous execution. One record is unchanged; one (with an existing key) has been updated; and two (with new keys) have been added:
11, AAAA -> no changes, so no further processing for this record22, XXXX -> 'Update' path44, DDDD -> 'Add' path55, EEEE -> 'Add' path
Also, one record from the previous execution was omitted from the current document. This results in a document that follows the 'Delete' path:
Id, Code33, CCCC -> 'Delete' path
Is there an easy way to highlight the changes that have occurred in the update path?
For instance if I had an xml document and 2 out of 10 fields have been modified since the last run. Is it possible to pull up the original xml document to check it against the updated one for specific field changes?
I'm afraid this is not currently possible, but similar ideas are being discussed here: Enable the Find Changes component to detect changed columns.
I suggest you 'Vote up' the idea and maybe add your own particular use case as a comment.
I understood that during initial execution, documents are forwarded down the "Add" path. During the subsequent execution, the initial document is the base reference for comparison. I have the following questions here:
1. Where does the initial document store during initial execution?
2. How does the subsequent execution access the initial document for its comparison?
Request you to clarify.
Retrieving data ...