Forum Discussion
jracer007
Helper IV
Helper IVReplace 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!!
jracer007Helper IV
Helper IVCould you help me with the formula please? I am new at this.
v-chuncz-msft
Community Support
Community Support- jracer007
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.- v-chuncz-msft
The first parameter <result_columnName> of LOOKUPVALUE Function needs to be the name of an existing column that contains the value you want to return.
- jracer007
I do not understand.