Export Output of Collect Values Tool in Model Builder

Discussion created by shino on Mar 23, 2013
Latest reply on Apr 8, 2013 by shino
Hi There,

I am new to model builder, I have built a model which calculates mean and minimum distance between features. It also counts how many of those near features fall within a given 'buffer' around a feature.

The user can select upto 6 buffer (/radius) lengths.  The tool will run and the final result is an excel file.  The excel file includes how many features fell within that given buffer but does not include the buffer distances that the user manually input in the beginning. 

So for those forgetful users, I'd like to add a column in the excel file that shows the buffer length.  I have added an image to this post, which shows visually what I want, because I'm not sure how coherent this explanation is.

Hopefully there is someone out there who can help me.  I've tried the merge, union and calculate values tool to somehow bring it all together, but no luck.

Thanks in advance!!