Sometimes you may have prefixes in common in row or column labels in tables and charts. For example, the table below contains "Preferred Cola" in the row labels and "Coca-Cola" in the column labels:
In these cases, you may want to tidy your table and remove the common prefixes.
The Tidy Row Labels and Tidy Column Labels rules extract common prefixes from the row/column labels or vector names to shorten the labels in the table or visualization.
Requirements
- A table or chart where the row or column labels contain common prefixes.
- These rules are currently not compatible with R-based visualizations (Create > Charts > Visualization).
Method
- Select the table or chart that contains row/column labels that you would like to tidy.
- Go to Automate > Browse Online Library > Modify Headers > Tidy Row Labels or Tidy Column Labels.
- Click OK.
Next