Mixing
Identify negative values in Collection using blue prism
[I have one collection named "Total Amount' and having column named "Amount", so i am fetching some amounts from one application and putting them into above collection under same mentioned column hence there are some negative amounts exists into it. So ideally my robot should recognize the negative amount under "Amount" column and if exists, should stop the bot.
blueprism rpa
asked Jan 2 at 10:14
Mayuri JuvekarMayuri Juvekar
11
add a comment |
[I have one collection named "Total Amount' and having column named "Amount", so i am fetching some amounts from one application and putting them into above collection under same mentioned column hence there are some negative amounts exists into it. So ideally my robot should recognize the negative amount under "Amount" column and if exists, should stop the bot.
blueprism rpa
asked Jan 2 at 10:14
Mayuri JuvekarMayuri Juvekar
11
Why not just utilize a loop and a decision stage? When a value is < 0, tie the result to an Exception stage and allow the Exception to terminate the process.
– esqew
Jan 2 at 12:37
Please see How to ask a good question? and include a Minimal, Complete, and Verifiable Example
– Ankur Aggarwal
Jan 3 at 3:26
add a comment |
[I have one collection named "Total Amount' and having column named "Amount", so i am fetching some amounts from one application and putting them into above collection under same mentioned column hence there are some negative amounts exists into it. So ideally my robot should recognize the negative amount under "Amount" column and if exists, should stop the bot.
blueprism rpa
asked Jan 2 at 10:14
Mayuri JuvekarMayuri Juvekar
11
[I have one collection named "Total Amount' and having column named "Amount", so i am fetching some amounts from one application and putting them into above collection under same mentioned column hence there are some negative amounts exists into it. So ideally my robot should recognize the negative amount under "Amount" column and if exists, should stop the bot.
blueprism rpa
blueprism rpa
asked Jan 2 at 10:14
Mayuri JuvekarMayuri Juvekar
11
asked Jan 2 at 10:14
Mayuri JuvekarMayuri Juvekar
11
asked Jan 2 at 10:14
Mayuri JuvekarMayuri Juvekar
11
asked Jan 2 at 10:14
Mayuri JuvekarMayuri Juvekar
11
asked Jan 2 at 10:14
Mayuri JuvekarMayuri Juvekar
11
11
Why not just utilize a loop and a decision stage? When a value is < 0, tie the result to an Exception stage and allow the Exception to terminate the process.
– esqew
Jan 2 at 12:37
Please see How to ask a good question? and include a Minimal, Complete, and Verifiable Example
– Ankur Aggarwal
Jan 3 at 3:26
add a comment |
Why not just utilize a loop and a decision stage? When a value is < 0, tie the result to an Exception stage and allow the Exception to terminate the process.
– esqew
Jan 2 at 12:37
Please see How to ask a good question? and include a Minimal, Complete, and Verifiable Example
– Ankur Aggarwal
Jan 3 at 3:26
Why not just utilize a loop and a decision stage? When a value is < 0, tie the result to an Exception stage and allow the Exception to terminate the process.
– esqew
Jan 2 at 12:37
Why not just utilize a loop and a decision stage? When a value is < 0, tie the result to an Exception stage and allow the Exception to terminate the process.
– esqew
Jan 2 at 12:37
Please see How to ask a good question? and include a Minimal, Complete, and Verifiable Example
– Ankur Aggarwal
Jan 3 at 3:26
Please see How to ask a good question? and include a Minimal, Complete, and Verifiable Example
– Ankur Aggarwal
Jan 3 at 3:26
add a comment |
2 Answers
2
active
oldest
votes
It's not clear to me whether you want to loop through the 'Total Amount' collection and filter the negative amounts out of there, or skip appending negative amounts to the collection when you're filling it.
Also it's not clear why you would want to stop the robot if you can just remove the negative values from the collection.
What I would suggest is to use the 'Filter Collection' action in the 'Utility - Collection Manipulation' object.
This action basically checks every item in the collection and matches it to your filter query (in this case "Amount < 0").
If the result is True, it will be put into the output collection, if not, if will be omitted.
Another way of doing it, is to loop through the collection using a loop and program the action you want to take with a decision stage when you come across a negative number like Esqew already said in his/her comment.
Hope this helps :).
answered Jan 17 at 15:25
RonRon
113
add a comment |
You can Filter the collection to check if there is negative values available in specific column. The Filter action under Utility - Collection Manipulation will allow you to save filtered data into in one more collection. Check the count of generated collection if it is greater than zero then the collection is having negative values else collection does not hold any negative value.
To Filter the collection please check the below screen shot: 
answered Jan 21 at 8:12
Vijay DodamaniVijay Dodamani
763
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54004491%2fidentify-negative-values-in-collection-using-blue-prism%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
It's not clear to me whether you want to loop through the 'Total Amount' collection and filter the negative amounts out of there, or skip appending negative amounts to the collection when you're filling it.
Also it's not clear why you would want to stop the robot if you can just remove the negative values from the collection.
What I would suggest is to use the 'Filter Collection' action in the 'Utility - Collection Manipulation' object.
This action basically checks every item in the collection and matches it to your filter query (in this case "Amount < 0").
If the result is True, it will be put into the output collection, if not, if will be omitted.
Another way of doing it, is to loop through the collection using a loop and program the action you want to take with a decision stage when you come across a negative number like Esqew already said in his/her comment.
Hope this helps :).
answered Jan 17 at 15:25
RonRon
113
add a comment |
It's not clear to me whether you want to loop through the 'Total Amount' collection and filter the negative amounts out of there, or skip appending negative amounts to the collection when you're filling it.
Also it's not clear why you would want to stop the robot if you can just remove the negative values from the collection.
What I would suggest is to use the 'Filter Collection' action in the 'Utility - Collection Manipulation' object.
This action basically checks every item in the collection and matches it to your filter query (in this case "Amount < 0").
If the result is True, it will be put into the output collection, if not, if will be omitted.
Another way of doing it, is to loop through the collection using a loop and program the action you want to take with a decision stage when you come across a negative number like Esqew already said in his/her comment.
Hope this helps :).
answered Jan 17 at 15:25
RonRon
113
add a comment |
It's not clear to me whether you want to loop through the 'Total Amount' collection and filter the negative amounts out of there, or skip appending negative amounts to the collection when you're filling it.
Also it's not clear why you would want to stop the robot if you can just remove the negative values from the collection.
What I would suggest is to use the 'Filter Collection' action in the 'Utility - Collection Manipulation' object.
This action basically checks every item in the collection and matches it to your filter query (in this case "Amount < 0").
If the result is True, it will be put into the output collection, if not, if will be omitted.
Another way of doing it, is to loop through the collection using a loop and program the action you want to take with a decision stage when you come across a negative number like Esqew already said in his/her comment.
Hope this helps :).
answered Jan 17 at 15:25
RonRon
113
It's not clear to me whether you want to loop through the 'Total Amount' collection and filter the negative amounts out of there, or skip appending negative amounts to the collection when you're filling it.
Also it's not clear why you would want to stop the robot if you can just remove the negative values from the collection.
What I would suggest is to use the 'Filter Collection' action in the 'Utility - Collection Manipulation' object.
This action basically checks every item in the collection and matches it to your filter query (in this case "Amount < 0").
If the result is True, it will be put into the output collection, if not, if will be omitted.
Another way of doing it, is to loop through the collection using a loop and program the action you want to take with a decision stage when you come across a negative number like Esqew already said in his/her comment.
Hope this helps :).
answered Jan 17 at 15:25
RonRon
113
answered Jan 17 at 15:25
RonRon
113
answered Jan 17 at 15:25
RonRon
113
answered Jan 17 at 15:25
RonRon
113
113
add a comment |
add a comment |
You can Filter the collection to check if there is negative values available in specific column. The Filter action under Utility - Collection Manipulation will allow you to save filtered data into in one more collection. Check the count of generated collection if it is greater than zero then the collection is having negative values else collection does not hold any negative value.
To Filter the collection please check the below screen shot:
answered Jan 21 at 8:12
Vijay DodamaniVijay Dodamani
763
add a comment |
You can Filter the collection to check if there is negative values available in specific column. The Filter action under Utility - Collection Manipulation will allow you to save filtered data into in one more collection. Check the count of generated collection if it is greater than zero then the collection is having negative values else collection does not hold any negative value.
To Filter the collection please check the below screen shot:
answered Jan 21 at 8:12
Vijay DodamaniVijay Dodamani
763
add a comment |
You can Filter the collection to check if there is negative values available in specific column. The Filter action under Utility - Collection Manipulation will allow you to save filtered data into in one more collection. Check the count of generated collection if it is greater than zero then the collection is having negative values else collection does not hold any negative value.
To Filter the collection please check the below screen shot:
answered Jan 21 at 8:12
Vijay DodamaniVijay Dodamani
763
You can Filter the collection to check if there is negative values available in specific column. The Filter action under Utility - Collection Manipulation will allow you to save filtered data into in one more collection. Check the count of generated collection if it is greater than zero then the collection is having negative values else collection does not hold any negative value.
To Filter the collection please check the below screen shot:
answered Jan 21 at 8:12
Vijay DodamaniVijay Dodamani
763
answered Jan 21 at 8:12
Vijay DodamaniVijay Dodamani
763
answered Jan 21 at 8:12
Vijay DodamaniVijay Dodamani
763
answered Jan 21 at 8:12
Vijay DodamaniVijay Dodamani
763
763
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54004491%2fidentify-negative-values-in-collection-using-blue-prism%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Why not just utilize a loop and a decision stage? When a value is < 0, tie the result to an Exception stage and allow the Exception to terminate the process.
– esqew
Jan 2 at 12:37
Please see How to ask a good question? and include a Minimal, Complete, and Verifiable Example
– Ankur Aggarwal
Jan 3 at 3:26