Insert/Update using Join Snap
Hi,
I am using Join Snap, to implement the logic of Insert new record and update existing one by doing join on target table. i defined left outer join to read all input records and in router i used...
Forum Discussion
Hi @khenderson,
I believe your problem would be solved if you add a Sort Snap before the Group By Fields Snap, and you sort by RevisionID. This is from the documentation for the Group By Fields Snap:
“The Snap expects the input documents with the same group-by field values are contiguous and whenever the group-by field values changes it produces a new output document. Therefore, if all input documents with the same group-by field values are expected to be grouped into one output document, the Sort Snap can be used in front of the Group By Fields Snap so that the input document stream are sorted by the group-by field values.”
It can be found at this location: https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1439014/Group+By+Fields
BR,
Dimitri
Hi Dimitri,
Thanks a lot for your reply.
Clearly I wasn’t reading the docs closely enough!
I’ll give it a go and let you know.
Thanks,
Kyle
