To process a workflow for a given list of customer names individually

[poornimak]

I have a workflow with some data processing. I want the workflow to run for each customer from a list of customers in an excel file and generate output file for each customer.

Example:

Customer List:

Customer name	Unique ID
Customer A	123
Customer B	234
Customer C	345

I have a workflow a.yxmd

Expected output:

a.yxmd should run for each customer - Customer A, Customer B, Customer C and generate separate excel output with Customer name as the output file name. Please note that my workflow a.yxmd also contains customer data. Any help would be appreciated.

TIA!!

[poornimak · Accepted solution]

@Qiu Thank you for the batch macro solution. Addition to it, I have a scenario for the same data.

I have Columns A, B, C, D, E F, H, I
Columns A, B, C, F, H, I are Static
Columns D, E are dynamic which might have account numbers appended dynamically.
I need my dynamic columns between the static columns in the order I desire. However, when my workflow runs for each client, my dynamic columns are not in proper order as shown in below examples.
I have given my current and expected outputs below.

Client 1:  

Current order of Output:

Column  A	Column B	Column C	Column E	Column F	Column H	Column I	Column D Account1	Column D Account 2	Column D Account 3

Expected order of Output:

Column A	Column B	Column C	Column D Account1	Column D Account 2	Column D Account 3	Column E	Column F	Column H	Column I

Client 2:  

Current order of Output:

Column A	Column B	Column C	Column F	Column H	Column I	Column D Account 4	Column D Account 5	Column E Account 6

Expected order of Output:

Column A	Column B	Column C	Column D Account 4	Column D Account 5	Column E Account 6	Column F	Column H	Column I

Client 3:  

Current order of Output:

Column A	Column B	Column C	Column E Account 10	Column E Account 9	Column E Account 8	Column D Account 7	Column F	Column H	Column I

Expected order of Output:

Column A	Column B	Column C	Column D Account 7	Column E Account 8	Column E Acount 9	Column E Account 10	Column F	Column H	Column I

Thanks in advance!

[Qiu · Accepted solution]

@poornimak 
I will prepare a predefined Column Names in required order then do some magic 😁