batch macro
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
i have a simple excel file with two column( product, sales) as shown below
product | sales |
A | 5 |
B | 10 |
I need a batch macro that accepts one product at a time, multiplies its sales by 2 and when i connect this macro to the workflow, i need final output as shown
product | macro output |
A | 10 |
B | 20 |
I need batch macro and not a standard macro because the real data is complex and uses a R code which can only take one product at a time. I am not sure how to configure the control parameter so that macro accepts one product at a time, doubles sales and moves to the next product and so on.
Solved! Go to Solution.
- Labels:
- Batch Macro
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
The key with a batch macro to control the number of records being brought in at a time is the group by tab in the configuration window. You can specify to group by the Product value, so records are brought in product by product.
See this article for more information about batch macros: