How to create a Macro to input new data from Input files into output template

Question

Hello,

I am currently working on a workflow where the input file needs to be updated more frequently. The challenge I'm facing is figuring out how to upload new data without modifying the workflow. Additionally, the new data needs to be mapped into a new tab in the output file. To help illustrate this, I've included two figures below.

Figure 1: Current Input file-

Item ColorGroup Amount AGreen I50DBlueII60BBlack IIII75CWhite III80

Figure: Same input with new data (last two rows)

Item ColorGroup Amount AGreen I50DBlueII60BBlack IIII75CWhite III80FOrangeIIIII55GRedIV45

Now how can i add Item F, G into new tab in the existing output file.

wirb · Answer

I'm sorry I don't have the solution and not sure how to tag the one above that I think you were trying to get.  @wirkKarl

kauser · Answer

@wirb

yes i agree and that's what i am looking for. can you please share workflow with batch macro that i can learn form.

thank you

WirkKarl · Answer

If your input file changes frequently and you don’t want to modify the workflow each time, the easiest option is to build a Batch Macro. The macro can read whatever new rows appear in the input and then route only the “new” items (F, G, etc.) into a separate output stream.