Forum Discussion

Bebo's avatar
Bebo
Helper II
4 years ago

Renaming Values in a Table Column

I have a column (named Sensor) in my table where the data values are alpha numeric identifiers (e.g. BCDDC2F1F056) for each sensor that is in use. Over time, senors are added as the system grows. I would like to replace these aplha numeric values with user friendly names (e.g. Diverter Valve 01). I have been doing this each time a sensor is added using transform. My question: Is there an interactive way to do this through an input variable table that would be contained in a visual in my report?

2 Replies

  • if there is limited sensors then you can achieve this by switch function

    • Bebo's avatar
      Bebo
      Helper II

      There are currently 23 sensors and typically there are 1-2 added per month. However, I do expect the number to grow to greater than 50 this year. That is why I was thinking about a more efficient (and easier) way to add or change sensor values from a visual table.