Updating Row(s) Macro

[knnwndlm]

Hi SME,

I'm trying to build a Batch/Iterative macro to insert a new row and updated a Rec ID in the dataset 1 based on the criteria in dataset 2. Dataset 2 has two fields:  Previous Row and Current Row.  The macro would locate the Previous Row in the dataset 1 and insert the Current Row under the Previous Row and update the Rec ID to account for the new row.

I'm unclear as to which macro to approach this.  I need two sets of input so the Batch Macro would make sense.  However, I also need a loop to go through dataset 2 one by one to gather the outputs together.  Right now, what you see in the attachment only has one row in the dataset 2, but this has multiple rows outside of the macro.

Appreciate your help with this.

Thanks,

kwl

[binuacs]

@knnwndlm this can be done without macro, solution attached

[Gaurav_Dhama_]

Can you give a broader input and output, with just one input it will not be possible to test. Also, can you provide a sample output that you would like to get?

[dreldrel]

Standrized macro should be enough for you, but if you always expect two of the same data sources in your pipeline, then you may dont need a macro.