All posibility combination in a Collection
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
17-01-22 11:14 AM
Hi,
I am working with blueprism and I have a smallproblem.
I have a collection with several columns related to finances and I need to find compensation. At this point, I need to know all the possible combinations within my collection, that is, if the collection has 10 lines I need to know all the possible combinations between those 10 lines (line 1 with line 2 would be a combination, but it would also be a combination to join the first 8 lines).
The collection with which we work can be 2 lines or 500, so I think that with code it would be faster.
can you help me, friends?
Thank you so much.
I am working with blueprism and I have a smallproblem.
I have a collection with several columns related to finances and I need to find compensation. At this point, I need to know all the possible combinations within my collection, that is, if the collection has 10 lines I need to know all the possible combinations between those 10 lines (line 1 with line 2 would be a combination, but it would also be a combination to join the first 8 lines).
The collection with which we work can be 2 lines or 500, so I think that with code it would be faster.
can you help me, friends?
Thank you so much.
5 REPLIES 5
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
17-01-22 04:56 PM
@Nazaret Martinez Bernal,
What is the definition of a "combination" here? You're talking about lines and columns. Is a combination taking every column from line X and adding it to every column of line Z? Is it just appending the columns of one line to the columns of every other line? There's quite a bit of ambiguity here. Can you post an actual example (maybe in Excel) with some sample data?
Cheers,
Eric
What is the definition of a "combination" here? You're talking about lines and columns. Is a combination taking every column from line X and adding it to every column of line Z? Is it just appending the columns of one line to the columns of every other line? There's quite a bit of ambiguity here. Can you post an actual example (maybe in Excel) with some sample data?
Cheers,
Eric
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
17-01-22 05:39 PM
Hi @Eric Wilson,
Sorry.
I need all combinations possibles between rows. For example, in a collection with 4 lines i can...
Line 1, Line 2,
Line 1, Line 3,
Line 1, Line 4,
Line 2, Line 3,
Line 2, Line 4,
Line 3, Line 4,
Line 1, Line 2, Line 3,
Line 1, Line 3, Line 4,
Line 2, Line 3,Line 4,
Line 1, Line 2, Line 3, Line 4
.
.
.
Thank you.
Sorry.
I need all combinations possibles between rows. For example, in a collection with 4 lines i can...
Line 1, Line 2,
Line 1, Line 3,
Line 1, Line 4,
Line 2, Line 3,
Line 2, Line 4,
Line 3, Line 4,
Line 1, Line 2, Line 3,
Line 1, Line 3, Line 4,
Line 2, Line 3,Line 4,
Line 1, Line 2, Line 3, Line 4
.
.
.
Thank you.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
18-01-22 09:22 AM
I think the number could be very large and probably too big for a collection. Can you explain the use case?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
19-01-22 07:11 PM
@Nazaret Martinez Bernal,
I'm still not entirely clear on your definition of a combination. Does this mean take the contents of row 1 and append the contents of row 2 to create a new row in a different Collection?
Ex. - We have Collection A, our raw data collection, with 3 columns and 3 rows defined in it. Then we have Collection B, which is our results/output collection.
Collection A
Row 1 = 12, 223, 456
Row 2 = 3, 65, 243
Row 3 = 99, 101, 200
After running the "combination" do we end up with
Collection B
Row 1 (Collection A R1) = 12, 223, 456
Row 2 (Collection A R1, R2) = 12, 223, 456, 3, 65, 243
Row 3 (Collection A R1, R2, R3) = 12, 223, 456, 3, 65, 243, 99, 101, 200
Row 4 (Collection A R1, R3) = 12, 223, 456, 99, 101, 200
Row 5 (Collection A R2) = 3, 65, 243
Row 6 (Collection A R2, R3) = 3, 65, 243, 99, 101, 200
Row 7 (Collection A R3) = 99, 101, 200
Or are you looking to perform a mathematical calculation (ex. addition) on the columns between rows?
Cheers,
Eric
I'm still not entirely clear on your definition of a combination. Does this mean take the contents of row 1 and append the contents of row 2 to create a new row in a different Collection?
Ex. - We have Collection A, our raw data collection, with 3 columns and 3 rows defined in it. Then we have Collection B, which is our results/output collection.
Collection A
Row 1 = 12, 223, 456
Row 2 = 3, 65, 243
Row 3 = 99, 101, 200
After running the "combination" do we end up with
Collection B
Row 1 (Collection A R1) = 12, 223, 456
Row 2 (Collection A R1, R2) = 12, 223, 456, 3, 65, 243
Row 3 (Collection A R1, R2, R3) = 12, 223, 456, 3, 65, 243, 99, 101, 200
Row 4 (Collection A R1, R3) = 12, 223, 456, 99, 101, 200
Row 5 (Collection A R2) = 3, 65, 243
Row 6 (Collection A R2, R3) = 3, 65, 243, 99, 101, 200
Row 7 (Collection A R3) = 99, 101, 200
Or are you looking to perform a mathematical calculation (ex. addition) on the columns between rows?
Cheers,
Eric
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
20-01-22 12:49 PM
@ewilson @John Carter
More or less...
I explain the context, because i have not explained myself well.
My process works with financial data, I have a collection A with several financial data, one of these columns is numerical (positive and negative numbers). I need to find among those numbers that rows add up to a specific value or a interval and return a collection B with the rows that comply it.
For example, i need the rows that numeric value add up to 0.
Row 1: 140,50
Row 2: 1504,60
Row 3: - 67,60
Row 4: - 110
Row 5: - 33,50
Row 6: 3
In this example, the collection B return the row 1,4, 5 and 6 because i need a value 0.
when I asked about the combinations, it was to test the sum of this value among all the available combinations
Thank you.
More or less...
I explain the context, because i have not explained myself well.
My process works with financial data, I have a collection A with several financial data, one of these columns is numerical (positive and negative numbers). I need to find among those numbers that rows add up to a specific value or a interval and return a collection B with the rows that comply it.
For example, i need the rows that numeric value add up to 0.
Row 1: 140,50
Row 2: 1504,60
Row 3: - 67,60
Row 4: - 110
Row 5: - 33,50
Row 6: 3
In this example, the collection B return the row 1,4, 5 and 6 because i need a value 0.
when I asked about the combinations, it was to test the sum of this value among all the available combinations
Thank you.