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.
Is there a way to prevent this from happening?
appreciate any comments