Return a special field in a text box

[HAMID_AKBARI]

I have a table of Equipments and  a table of their technical specifications.

every row of specification table  has two column :a specification title and specification value.

e.g       Manufacturer              ----  PHILIPS

            date of Manufacture   ----   2005

I want to show a special record in a text box that represent e.g manufacturer of equipments when an Equipment select.

Since the records are not same in specification might be diffrent in words e.g "manufacturer" or "manufacture by" or "made by"...

so the solution should regar search with like..

Thanks in advance.

[Vegar]

I found it hard to get a grip on how your data look like. Is the examples above two rows and two columns, or two rows but one column?

It would help a lot if you could showcase a small sample of your data, including rows with "manufacturer" or "manufacture by" or "made by". Please also explain how the output you would be based on your sample data set.

[HAMID_AKBARI · Accepted solution]

it was solved by Rubmarin in Other post

=Only({<SP_DESCRIPTION={"*Manufact*"}>-<SP_DESCRIPTION={"*Date*"}>} SP_VALUE)

Thanks by the way

[Vegar]

Thanks for updating this thread as well with the solution.

I assume it is this response by @rubenmarin  that you are referring to: https://community.qlik.com/t5/App-Development/Return-a-field-from-one-column-by-other-column-name-li...