Divyarani411
Member
Need you help/inputs for below scenario.
I have a collection with 2K records and I need to filter that collection based on the business rules.
For example: Collection A contains 4 columns i.e P,A,C,E and also has data(values) in it.
I have filter rules like below
if P column = "D" and A column = "Unassigned" than add one more column to collection A (i.e Type col)and add value as TypeD .
if P column = "R" and A column = "Unassigned" and E column = "EVC" than add value as TypeR to that new added column i.e Type.... etc like this i have 5 to 6 business rules (each business rule picks different col so i cant use filter action).
So my thought on this is
1) For adding column on existing collection i.e A by using "Append Field " Action in collection manipulation
2)Using choice stage i will give multiple decisions and sort the data and after that I m using set collection field to update the data. But The conditions which I am giving are not working.
Please help me to use this choice stage or Please give me suggestions on different method of approach. Thank you!
I have a collection with 2K records and I need to filter that collection based on the business rules.
For example: Collection A contains 4 columns i.e P,A,C,E and also has data(values) in it.
I have filter rules like below
if P column = "D" and A column = "Unassigned" than add one more column to collection A (i.e Type col)and add value as TypeD .
if P column = "R" and A column = "Unassigned" and E column = "EVC" than add value as TypeR to that new added column i.e Type.... etc like this i have 5 to 6 business rules (each business rule picks different col so i cant use filter action).
So my thought on this is
1) For adding column on existing collection i.e A by using "Append Field " Action in collection manipulation
2)Using choice stage i will give multiple decisions and sort the data and after that I m using set collection field to update the data. But The conditions which I am giving are not working.
Please help me to use this choice stage or Please give me suggestions on different method of approach. Thank you!