Hi N,
Ok, next question (just to be sure):
So you have two collections in BP, one collection from the XL and another collection from SAP. Right?
If we assume the above to be true, you got a number of options:
- Count the number of rows of both collections. If not the same, the collections are different.
- Loop through one of the collections, checking each row against the other collection using the 'Collection contains value' action. If not found, the collections are different.
- Compare the collections directly with the 'Intersection Between Collections' action.
- Search for one of the previously described collection compare solutions on this community. (I'm quite sure there's one showing a code stage doing what you want)
Note that if the collections are big, a code stage might be preferable to a native BP solution due to higher speed and lesser memory consumption.
Happy coding!---------------PaulSweden
Happy coding!
Paul, Sweden
(By all means, do not mark this as the best answer!)