Encounter error when iterate rows to generate specific excel files.

Question

Hello,

I've encountered a problem where I can't iterate through and output a specified Excel report.

The requirements are as follows:

1, Read mapping.xlsx, as shown:

2, The data in the table corresponds to specific paths, A.xlsx, B.xlsx, C.xlsx, D.xlsx, as shown:

3, I need to iterate through the rows of the mapping data, open each path specified in a row, then union all the data and generate a single Excel file. For example, based on the data in mapping.xlsx, we should generate 312.xlsx and 131.xlsx, as shown:

4, Currently, both the 312.xlsx and 131.xlsx files that I've generated output the same content which is wrong, as shown:

Any ideas how to solve this one?

Thank you!!!

gen1.yxmc

result.yxmc

AncientPandaman · Answer

the key issue is assigned random number before all data merged.

batch macro mean each line will run once. so 2 line mean run twice, hence each run got 2 different identify.

hence, i changed the macro to load files only.

then in the output, only then add the random and fullpath.

and duplicate whole set for B.

so it will become:

mapping > load all locA files > assign identify > path  > output

> load all locB files > assign identify > path  > output

result.yxmc

gen1.yxmc

Crazycc · Answer

Really thanks for your rely, i tried to fix it like you said, but still not working.

jrgo · Answer

Your 2 "Action" tools are not configured correctly. You need to SELECT the attribute you want it to update.

How you currently have it configured:

Should be configured like this: