Get the Unique values from two collections

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,



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

Good Luck.