comparing collection

M

Malligai

Member
Hi ,

Am having 2 collections now. One is with some 20-30 items. Another collection(source collection) may have 700-900 items. I have to retrieve the common date into output collection, and mismatched item also i have to add into the source collection.

Easy understanding :
sample collection : 20-30 rows (only one column)
Source collection : 700-1000 (only one column)

Result needed : checking the sample collection values into the source collection. If the value is found, then it should drop in ouputcollection, if it is not macthes, then it should go and add those value into source collection.

Please assist to get this.
 
S

sreejith

Member
Hi!
You can use a loop stage to iterate the sample collection and check the values in the source collection by using the action 'Collection contains values' of 'Collection manipulation' VBO.
 
M

Malligai

Member
hi sreejith, the collection contains value will work with 2 collections? I have tried, but its not working good.
 
S

sreejith

Member
You don't need two collections.
Idea is loop the first collection(here sample collection), take each row value and apply it in 'collection contains values'.
In that collection name: <source collection>
column name: <your column name in source collection>
Exact value: <Value taken from sample collection (via loop)>
 
You must log in or register to reply here.
Top