Get the Unique values from two collections

srikanthp

New Member
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

  • 1558546265987.png
    68.6 KB · Views: 43
  • 1558546312065.png
    11.7 KB · Views: 33

Sukesh Kumaru

Active Member
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