I have a dataset that translates a code into words:
Code | Translation
W | Weight
L | Length
P | Pressure
and so on.
Is there a way to script a translation from the dataset similar to using SQL?
SELECT Translation FROM table WHERE Code = “W”
If not, could I turn the dataset on its side?