- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
21-12-23 08:56 PM
So I have this collection that is [test] I am trying to determine whether [test.county] contains one of 80 possible test strings. At the moment I have a decision stage with
[test.county] = "test" OR
[test.county = "test2" OR
for all 80 of the possible text strings. I was wondering if there would be any way to more efficiently do this rather than the 80 separate OR statements.
If anyone has any feedback or ideas for this please let me know, thanks in advance.
------------------------------
Jari Carlson
------------------------------
Answered! Go to Answer.
Helpful Answers
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
22-12-23 08:51 AM
I would use the Utility - Collection Manipulation Extended and the action Collection contains value. This will let you set the collection you want to search, the column you want to search in and the term you need to search for. If the 80 values you need to search are static then add them to a collection and loop the collection to search for each term. Screenshots below.
------------------------------
Michael ONeil
Technical Lead developer
NTTData
Europe/London
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
21-12-23 11:11 PM
Hi Jari Carlson,
You can use environment variable and pass as comma seperated values and extract this value as csv Collection.
Once all the values are in collection you can use this extraction collection as nested collectio to verify different condition.
This way you can modify to add new string or remove the existing with out changing the code.
You can also use code stage to perform this,
------------------------------
-----------------------
If I answered your query. Please mark it as the "Best Answer"
Harish Mogulluri
Lead developer
America/New_York TX
------------------------------
If I answered your query. Please mark it as the Best Answer
Harish Mogulluri
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
22-12-23 08:51 AM
I would use the Utility - Collection Manipulation Extended and the action Collection contains value. This will let you set the collection you want to search, the column you want to search in and the term you need to search for. If the 80 values you need to search are static then add them to a collection and loop the collection to search for each term. Screenshots below.
------------------------------
Michael ONeil
Technical Lead developer
NTTData
Europe/London
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
27-12-23 07:34 PM
Do you know where to find the utility Collection Manipulation Extended? I have looked around and done some googling but I can't find anywhere that mentions that as something that is available through official means.
------------------------------
Jari Carlson
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
27-12-23 09:18 PM
Regards
------------------------------
Leonardo Soares
RPA Developer Tech Leader
Bridge Consulting
América/Brazil
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
05-01-24 10:37 AM
Hi Leonardo
This may be a stupid question, but how do I import an xml file in to BPC? I only have these options to import a release:
Many thx
Ian
------------------------------
Ian Meldrum
Senior RPA Developer
Royal Surrey NHS FT
UK
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
06-01-24 02:48 AM
------------------------------
Leonardo Soares
RPA Developer Tech Leader
Bridge Consulting
América/Brazil
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-01-24 10:27 AM
Hello Ian,
Can you try importing it as a Process / Object
------------------------------
Ifeoma Igweze
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
10-01-24 03:02 PM
Hi Ifeoma, that option is not available unfortunately
------------------------------
Ian Meldrum
Senior RPA Developer
Royal Surrey NHS FT
UK
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
10-01-24 03:04 PM
Thanks Leonardo, look forward to receiving it shortly 🙂
------------------------------
Ian Meldrum
Senior RPA Developer
Royal Surrey NHS FT
UK
------------------------------
![](/skins/images/3CCE9DA4F28CA98E3CC8BF54ECC3AD71/responsive_peak/images/icon_anonymous_message.png)