merge individual 2D matrices

3.50K 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

Anyone have an example of union in Datalink

0

However….

What if I am importing two separate 2D matrices. I keep them as 2D to ensure sparsity. Then I add some columns and do a number of calculations in each matrix.

Now, I want to combine these two matrices into a new matrix with categories. I can’t figure out how to do it in Datalink, and I don’t want to have to write a bunch of formulae to pull into the new matrix.

How do I do that? Thanks.

Conor

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.

0

Why don’t you import the merged data into the 3rd matrix directly from the database via datalink? If both queries have the same structure, you can import both with a SQL statement
[1st query]
UNION
[2nd query]
You sould use SQL expert mode in the datalink.

I think this is more convenient than using a datalink from the 2d matrices into the third one, which entails modifying the datalink twice,
A) point to the first matrix, import with option for substituting existing data
B)point to the second matrix, import with option “Append rows to existing matrix”.

Bye

Latest Questions