merge individual 2D matrices

4.57K viewsTips and Techniques


I would like to merge individual 2D Matrices within Quantrix into a summary Matrix which is also a 2D Matrix.

Could anyone help how to resolve this?

I attached a sample file for better understanding.
January and February matrices are linked to an outside database to import monthly items and has the same structure.
I just simply want to merge/ add all items/rows into the third matrix (2D matrix for All months).
The monthly matrices can change dinamicaly and for audit trail purposes I want to keep separate from the cummulative matrix. That is why I don’t want to import the monthly data into the same matrix through Datalink.

thanks for any advice,


I’d have to agree with Luca.

The only thing that’s changing is the data. Just create SQL that extracts the data you want.

You are viewing 1 out of 4 answers, click here to view all answers.

Latest Questions