polugopi87
Member
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.
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.