Return a field from one column by other column name like somthing

[HAMID_AKBARI]

Hi Community

i have database of diffrent Equipments and their Technical Specifications.

Unfortunately the data Specification Entities are not equal by name eg

sometimes maker company Entered "manufacturer" and sometime "Manufactured By"

The DB structure sample is attached 

Now the Problem:

I want to create a panel that user select an Equipment and the the spec value shown in text box.

Infact need a script that Return "SP_Value" that "SP_Description" Like "Manufact" for text box one and

Return "SP_Value" that "SP_Description" Like "Date" for textbox two and .....

[rubenmarin · Accepted solution]

Hi, the expression could be:

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

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

But I think it would be easier if you solve it in script, apply a mapping so it converts all differnt values to the same, also you can convert the date values to something that doesn't have the 'Manufact' word in it.

[HAMID_AKBARI]

Thats it.Very nice.Thank you