Get the Unique values from two collections

#1
Hello everyone
I have a collection 1 which contains the source data. Using the collection 1 i have performed certain action and as a result I got the Collection 2(Without duplicates) which is a subset of one of the columns of columns of collection 1. Now I have to compare collection 1 and collection 2 and extract all the rows of collection 1 referring collection 2. In the collection 1 the column is EBELN and in collection 2 the column name is "Message text". Both are PO numbers. Now I have to look at the common PO No's in both collections and get all the rows associated with the PO numbers. Please advice.

Thanks in advance,
Srikanth.
 

Attachments

#2
Hello,

Then Loop Collection2 by using Action called Collection contains value if it returns True then copy entire row to another collection.

Good Luck.
 
Top