I'm coming from 10.5 to 14.3 so I may be stuck in my ways and I need a bit of help with understanding some of the changes! The way we've used 10.5 is that I make the models and others use them on a series of reports/excel sheets that are generated monthly - they open the new file, apply a saved model and export the summaries. It's important that it all works as smoothly as possible as I'm the only one that has any experience of Monarch outside opening & exporting. The only reason we've gone to 14 is because we needed more licenses.
Am I right in thinking there's no way of incorporating something done in Data Prep Studio into a model? Is DPS mainly for non-recurring tasks?
What's prompted this is that I have an Excel file as my data source. In DPS I can specify a number of lines to be skipped when I open it but I can't see a way to do that in Classic Mode (and so incorporate it into a model.) Building this into a model reduces the steps involved when my colleagues come to open the files and apply the models.