Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

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

Crazycc
6 - Meteoroid

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:

 

image.png

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."

3 REPLIES 3
geraldo
13 - Pulsar

@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.

Crazycc
6 - Meteoroid

 

@geraldoYour understanding is correct. Could you please explain in detail how to use batch macros to iterate through rows
geraldo
13 - Pulsar

@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

Labels
Top Solution Authors