how to get XX##other##text text information from .csv file?

[augusto.gehlen]

Hello,

I would like to know how do I get the text information to use in the lookup table?

Sorry for my English!! 🙂

[iainsavage]

Text isn’t a valid unit.

A text parameter would be unitless so I think you just want the column heading to be CODIGO##other##

[iainsavage]

To get the correct code you also need to use a parameter with a unique value, or a unique combination of several parameters, as the search term. In your screenshot the value of C is the same in every row, so what is different about each type to point towards the appropriate code?

[augusto.gehlen]

This is my table structure.

[L.Maas · Accepted solution]

Screenshot with an example

Note the nn##OTHER## and not nn##OTHER##TEXT