Question
How to convert text strings to an arbitrary string if there is a string that matches a condition.
<Example>
If the data contains "data", then the data should be converted to "Data Rockstar" as follows.
Last Modified Date: 26 May 2022
Environment
- Tableau Desktop
Answer
1. Connect to Sample_data.xlsx.2. Drag [No.] and [Data] to Rows.
3. Create a new parameter as following settings.
4. Right click on [Parameter 1] -> Show parameter
//Enter the string you want to search for in this parameter.
5. Create a new Calculated field as following settings.
Name : Converter
Calculation : IF CONTAINS([Data],[Parameter 1])
THEN "Data Rockstar"
ELSE [Data]
END
6. Drag [Converter] to Text.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials