Copy Data from Datalink to New Matrices

Generic selectors
Exact matches only
Search title only
Search in content
Search in all posts
Search in pages
Answers
Questions
Solved4.19K viewsDataLink
0

Hi,
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?

Thank you

Changed status to publish
0

Hi Mike,
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.

Attachments

Filters.model
You are viewing 1 out of 9 answers, click here to view all answers.