How to Filter Collection

[polugopi87]

Hi friends,
i have 2 collections containing the following fields.

Collection 1 :

1.Name
2.Gender
3.Age
4.Qualification
5.City
6.Salary
7.Unique ID
8.Invoice Date
9.Invoice Amount
10.PO Number


Collection 2 :

1.Unique Id
2.Id number
3.Status
4.Ownership Id

i need to match two collections using Unique id filed .if unique id is matched then i need to add two collections and i need to store the final data into new collection containing below fields only.

Final collection fields:

1.Unique id
2.Invoice date
3.Invoice amount.
4.ownership id
5.PO number
6.status

can anyone please suggest me how can i use filter collection action from collection manipulation.

 

[syed]

Hi friends,
i have 2 collections containing the following fields.

Collection 1 :

1.Name
2.Gender
3.Age
4.Qualification
5.City
6.Salary
7.Unique ID
8.Invoice Date
9.Invoice Amount
10.PO Number


Collection 2 :

1.Unique Id
2.Id number
3.Status
4.Ownership Id

i need to match two collections using Unique id filed .if unique id is matched then i need to add two collections and i need to store the final data into new collection containing below fields only.

Final collection fields:

1.Unique id
2.Invoice date
3.Invoice amount.
4.ownership id
5.PO number
6.status

can anyone please suggest me how can i use filter collection action from collection manipulation.

It can be achieved using nested loop.

But if you are familiar with C# or VB script then it can be done in 5 to 6 lines of code using code stage(again here you have to use nested for loop.

 

[polugopi87]

It can be achieved using nested loop.

But if you are familiar with C# or VB script then it can be done in 5 to 6 lines of code using code stage(again here you have to use nested for loop.

Could you please share c# or vbcode if possible
And also please share BP code if possible (using collection manipulation )

 

[Manjit Sahni]

Try this "[Col1] = '"&[Cond1]&"' and [Col2]='[Cond2]'"