How to iterate through rows of data, and then perform subsequent ETL processing for each.

Question

Step 1. There are 4 data sources A, B, C, D. After reading them, ETL processing is performed to generate an Excel report (this part has already been completed), as shown in the figure:

Step 2. The 4 data sources are dynamic. Upstream of them, I am maintaining a mapping table (in Excel format). This table contains fields such as cor_id (company name), loc_A, locB, locC, locD (absolute paths to the Excel files). I need to iterate through the rows of the mapping table. Each row of data serves as the input parameters for the 4 data sources in step one. After completing the process for the first row, the entire process needs to be executed again for the second row, and so on."

geraldo · Answer

@Crazycc

I didn't quite understand what your 4 entry bases are.
The batch macro can receive the parameter of each line through the control parameter tool. for each item you need to use in the macro, you put this tool and you can combine it with the input macro for each base and with a single extraction within the batch macro it will process each parameter line for the input bases.
ideally you would attach a sample data

Crazycc · Answer

geraldoYour understanding is correct. Could you please explain in detail how to use batch macros to iterate through rows

geraldo · Answer

@Crazycc

In my understanding it's kind of like doing a batch macro. In the main workflow are the parameters and making the necessary adjustments in your workflow it will process each line received from the main workflow.