Batch Macro Query

pdave87

Hi all SMEs,

Quick question:

I'm in process of learning batch macros. I created a very small sample sales data for my learning with two inputs.

1. Product orders - product + date + quantity

2. Product pricing - product + price

Batch macro provides output - product + price + order total. I have my desired output as order total however, I want to add the date and quantity ordered in the output which is where I am stuck. Input and macro is attached for reference. 

BM_Sales_Data.yxmc

Sales_Data_Output.yxmd

DawnDuong

hi @pdave87 

Probably you did not understand what I was trying to say - or i did not say it clearly enough.

for data to be consumed by a macro and included in the output, it needs to be input via either the input anchor or the "inverted question mark anchor". The "inverted question mark anchor" is the data that needs to be updated at every batch run, i.e. pertaining to the 2nd bullet point.

You need 1 separate Control Parameter Tool for every field you want to input via the "Inverted question mark anchor":

• Firstly, you will need to have 2 Control Parameter Tool in the macro because you require 2 fields [Quantity] and [Date]
• Secondly, once the the input is taken by the macro you can process it like a field in your data. In this case, to keep show the original [Quantity] and [Date] associate with each input, you only need to take those inputs into formula field like something below.

Once you do this then the outcome the new fields as well as allowing you to split by order date.

Hope this helps you.

Last but not least... I saw the "other SME's" part after I've finished updating the reply and workflow. 😉 But I decided a ignore that snub in the spirit of trying to be helpful and nice to each other.

Cheers,

Dawn.

Sales_Data_Output.yxzp