AnsweredAssumed Answered

Problem with parameters in a model within a model

Question asked by AIRO_MU on Sep 16, 2016
Latest reply on Sep 21, 2016 by AIRO_MU

I have been developing a detailed demographic profiling model that allows users to draw a user defined area and pull back a demographic profile.


Within the main model there is a sub-model (DataPrep) that contains a .py script that runs a series of key data prep routines (adding new columns, calculations, transposing etc) to produce the final table. Within this sub-model I then have another sub-model that contains the 'Table to Excel' tool - this take the final table and exports it to an excel file. This all works fine and the overall model runs in the correct order. 


However, if I make the output from the 'Table to Excel' tool a parameter it causes the 'Table to Excel' tool to run before the .py script that does all of prep work on the data.I need to have the output of the 'Table to Excel' as a parameter in the main model as I am using this model to publish as a service for a geo-processing widget in a Javascript viewer.


Is there a way to prevent this from happening?


appreciate any comments