I would like to use the model builder to solve OD Cost Matrix in iterations because my origins/destinations FC need to be grouped by attributes. I use the Iterate Feature Selection tool to do so. After performing all OD Cost Matrix in loop, I want to merge all result lines into a single FC and export its table into an excel sheet.
I separate the Iteration part of the process into a subModel with a Collect Values as output:
Then I use the subModel output into another model to do the merge and the export to excel:
The subModel seems to run in iteration correctly, but when it's time to merge the output I got these errors:
ERROR 000622: Failed to execute (Merge). Parameters are not valid.
ERROR 000400: duplicate input not allowed
Can someone have an idea what is incorrect in my process?