Filter value by text, get back value/text

[Anonymous]

I need help on creating a filter that finds corresponding data to ID from VALUE by using text filtering form DESCRIPTION

for example: i need to filter all values that are named "Value A" in description and have (text or number) in value table

ADDED INFO: all data is on a SQL server.

At the moment if I use matrix table i get results, i cant just manage the values in logical order or chose what i want to show

 

I would want to have the table like this, 

Tables what are now use are: 

D_Equipm, Equipm [ID]

F_Feed, Feed [Description]

F_Feed, Feed [Value]

   

[Bifinity_75]

Hi @Anonymous , You need to create another table and set a value for order by description, like the image: (adding an index column):

- You must create the following relationship:

- And last, insert matrix object, and sort rows by the order, like the image:

Best regards

[Anonymous]

This is not possible due to SQL database and I cant add the new table, also i will use other data related to the ID 

The description table will be a mix of at the moment 178 different descriptions and 12800 Values (just started gathering data)

I have tried to make a formula that woud count the row number and return the same row from Value