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