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.18K 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,
Can you be more specific about this, I could not find any inbuilt function "where".
I do understand that Filters can be created as formulas in new matrix but to import the filtered data i have to manually create rows and columns.

In matrix A (Unfiltered data) Rows -80000, columns -10.
matrix B (Filtered data) Rows – 2100, Columns – 10.

Every day the database is updated and number of rows in matrix A increases which results in increase of matrix B rows. I tried to do this by linking matrix A & B but this results in creating 80000 rows in matrix B. I want the rows equivalent to the filtered data obtained.

Why can’t i use the inbuilt filters and link both matrix?

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