How to iterate through rows of data, and then perform subsequent ETL processing for each.
- 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
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."
- Labels:
- Iterative Macro
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- 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
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
