I have data from several runs of a numerical modeling tool. The data always has the same structure - e.g. fixed set of rectangular vector tiles - no matter if there is a "valid" output or zero.
It looks like this (I only put some random data inside):
The attributes also always have the same names - "cell", "value" and "maximum" where "cell" is ID of particular vector tile:
I am probably going to have several tens or hundreds of such datasets and I was asked if it is possible to join them into one vector layer with several attribute columns for each model run.
The ways to merge shapefiles do not expect same geometries so I would probably end with unnecessary overlapping tiles... while the vector tiles remain the same and only the attribute values change.
I would probably be able to put together some CLI linux script first converting all the DBF files to CSV and somehow rename the column names based on the filename to avoid conflicts and finally join it with the geometries - in QGIS, maybe or some sort of geodatabase...
Or is there any better way to do this?
PS: can share some testing data if it helps