I am using Data Link to connect to my database and import data. After importing the data I have applied different filters to eliminate unnecessary data. I am trying to copy this filtered data in to a new matrix and when ever i update my datalink i want the new matrix also to be updated, but linking the columns is resulting in transferring unfiltered data in to a new matrix.
Is there any procedure to connect filtered data obtained from Database to a newmatrix?
I have attached a sample model. In this model assume that Data in Matrix A is obtained from datalink and gets changed when ever datalink is updated. Currently there are 30 rows of data and after filtering the data based on Type: SO10, Month: 6, City: Indio we obtained 12 rows, I want to link this filtered data in to a new matrix B(I.e Matrix B should contain only 12 rows of data). If the data in matrix A increases then matrix B should also have changes with rows inserted or deleted.