1 BEST ANSWER
Helpful Answers
Hi @Erjola Mema,
You can try executing a loop within the collection and Read the Values and further using a decision stage with logic as shown below will work i believe.
You will require another collection to add the numbered values in this way.
------------------------------
Saurabh Goswami
RPA Architect
Ericsson
------------------------------
You can try executing a loop within the collection and Read the Values and further using a decision stage with logic as shown below will work i believe.
You will require another collection to add the numbered values in this way.
------------------------------
Saurabh Goswami
RPA Architect
Ericsson
------------------------------
Hi Erjola,
The reason why you are not getting proper output is because of the fact that you can't simply combine regex or regular expressions in Filter Query for collections. LIKE keyword only works with static values that you provide. In your case, you can provide a query as: [Section] LIKE '%A%' OR [Section] LIKE '%B%' and so on. Such a query wont just be long but also might be difficult to maintain.
A better approach as per me would be to go first iterate your input collection, then use the 'Test Regex Match' action from the 'Utility - Strings' VBO where you can provide the input text string as [Input Collection.Section] and the regular expression as "
NOTE: Please check the name of the collection and the column and modify as per your use.
Next you can check the value of the flag data item, if the value is True then it means the current column value contains a string and you can simply skip the loop otherwise you can add a new row to another collection call 'Outputs' let say which should have the same schema as that of your Input collection using the 'Add Row' action from 'Internal-Collections' VBO and then you can simply set the value of the current column of the input collection to the same equivalent column of the output collection.
Please find the below screenshots for your reference:
Workflow Diagram:
Test Regex Match Action Property:
Add Row Action Property:
Calculation Stage Expression:
------------------------------
----------------------------------
Hope it helps you and if it resolves you query please mark it as the best answer so that others having the same problem can track the answer easily
Regards,
Devneet Mohanty
Intelligent Automation Consultant
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com
----------------------------------
------------------------------
The reason why you are not getting proper output is because of the fact that you can't simply combine regex or regular expressions in Filter Query for collections. LIKE keyword only works with static values that you provide. In your case, you can provide a query as: [Section] LIKE '%A%' OR [Section] LIKE '%B%' and so on. Such a query wont just be long but also might be difficult to maintain.
A better approach as per me would be to go first iterate your input collection, then use the 'Test Regex Match' action from the 'Utility - Strings' VBO where you can provide the input text string as [Input Collection.Section] and the regular expression as "
[A-Za-z]+" and store the output to a flag type data item.NOTE: Please check the name of the collection and the column and modify as per your use.
Next you can check the value of the flag data item, if the value is True then it means the current column value contains a string and you can simply skip the loop otherwise you can add a new row to another collection call 'Outputs' let say which should have the same schema as that of your Input collection using the 'Add Row' action from 'Internal-Collections' VBO and then you can simply set the value of the current column of the input collection to the same equivalent column of the output collection.
Please find the below screenshots for your reference:
Workflow Diagram:
Test Regex Match Action Property:
Add Row Action Property:
Calculation Stage Expression:
------------------------------
----------------------------------
Hope it helps you and if it resolves you query please mark it as the best answer so that others having the same problem can track the answer easily
Regards,
Devneet Mohanty
Intelligent Automation Consultant
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com
----------------------------------
------------------------------
Hi @Erjola Mema,
You can try executing a loop within the collection and Read the Values and further using a decision stage with logic as shown below will work i believe.
You will require another collection to add the numbered values in this way.
------------------------------
Saurabh Goswami
RPA Architect
Ericsson
------------------------------
You can try executing a loop within the collection and Read the Values and further using a decision stage with logic as shown below will work i believe.
You will require another collection to add the numbered values in this way.
------------------------------
Saurabh Goswami
RPA Architect
Ericsson
------------------------------
