spine-tools / Spine-Toolbox

Spine Toolbox is an open source Python package to manage data, scenarios and workflows for modelling and simulation. You can have your local workflow, but work as a team through version control and SQL databases.
https://www.tools-for-energy-system-modelling.org/
GNU Lesser General Public License v3.0
71 stars 17 forks source link

Import data into the same parameter value #1673

Open manuelma opened 2 years ago

manuelma commented 2 years ago

Often, we want to build a single time series or a map using data from several files/sheets. This is impossible at the moment, but it could be achieved by defining multiple mappings with the same parameter value as target. When running the importer, the data from the different mappings would be merged into the single parameter value.

What is possible at the moment is to merge data comming from an importer into data currently existing in the database, so maybe we can repurpose part of that functionality to achieve what I propose? Will give it a try now.

manuelma commented 2 years ago

This is done and working, but we need two more things: