Apply formula to dynamic number of rows and columns
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
tomcolli
5 - Atom
‎02-22-2024
05:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I have a dataset where the number of columns and rows changes each time the workflow is run.
I need to apply a formula to each cell of this dataset - each entry has a multiplier and a variable number of "Data" columns. Each "Data" column needs multiplying by the multiplier in that row.
Example:
Input Data:
Record | Multiplier | Data Col 1 | Data Col 2 | Data Col 3 | Data Col 4 |
a | 2 | 10 | 15 | 10 | 20 |
b | 2.5 | 20 | 15 | 5 | 5 |
c | 2 | 10 | 15 | 10 | 20 |
d | 1 | 20 | 15 | 5 | 5 |
e | 5 | 25 | 30 | 40 | 30 |
f | 4 | 20 | 15 | 5 | 5 |
Output:
Record | Multiplier | Data Col 1 | Data Col 2 | Data Col 3 | Data Col 4 | Result Col 1 | Result Col 2 | Result Col 3 | Result Col 4 |
a | 2 | 10 | 15 | 10 | 20 | 20 | 30 | 20 | 40 |
b | 2.5 | 20 | 15 | 5 | 5 | 50 | 37.5 | 12.5 | 12.5 |
c | 2 | 10 | 15 | 10 | 20 | 20 | 30 | 20 | 40 |
d | 1 | 20 | 15 | 5 | 5 | 20 | 15 | 5 | 5 |
e | 5 | 25 | 30 | 40 | 30 | 125 | 120 | 200 | 150 |
f | 4 | 20 | 15 | 5 | 5 | 80 | 60 | 20 | 20 |
So, .e.g for record E, each "Result" column is the equivalently numbered "Data" column multiplied by the multiplier for E (5).
Any help would be appreciated!
Thanks
Labels:
- Labels:
- Dynamic Processing
- Workflow
4 REPLIES 4
binuacs
21 - Polaris
‎02-22-2024
09:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@tomcolli one way of doing this
aatalai
14 - Magnetar
‎02-22-2024
01:53 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@tomcolli look at the multi field tool, selecting the data columns
and then setting it to multplier*[current field]
Hope this helps
nagakavyasri
12 - Quasar
‎02-23-2024
01:22 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
flying008
15 - Aurora
‎02-25-2024
07:03 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
