Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Filter value by text, get back value/text

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]

 

 

   

2 Replies

  • 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's avatar
      Anonymous
      Not applicable

      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