Forum Discussion

jracer007's avatar
jracer007
Icon for Helper IV rankHelper IV
8 years ago

Replace Text with other text

Hello community, I want to request your help to replace the text of a Custom Column with the text of other column. Original Text: Desired text: Thank and happy year!!
Need Help
  • jracer007's avatar
    jracer007
    Icon for Helper IV rankHelper IV
    8 years ago

    Could you help me with the formula please? I am new at this.

    • v-chuncz-msft's avatar
      v-chuncz-msft
      Icon for Community Support rankCommunity Support
      8 years ago

      jracer007,

       

      Share us a more complete example, please.

      • jracer007's avatar
        jracer007
        Icon for Helper IV rankHelper IV
        8 years ago

        I'll explain it to you in more detail, My data source comes from Google Analytics:



        Then I create a Custom Column to extract the data I need with a lookupvalue:


        This is the data source that contains the search column:


        And the visualization (matrix) is this:


        Now, what I need is for all that text to be replaced by this:



        Note: This text is in the same table as the replacetext_3 image.