merge individual 2D matrices

4.57K viewsTips and Techniques
0

Hello,

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,
Mark

0

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