Define a synonym

Make a column easier to find by assigning to it a synonym. This is helpful, for example, when different departments refer to the data using different terminology.

When users search a data source, they might try typing different words to try to retrieve a particular column. This could be due to different groups in your organization using different terms for the same data. Or maybe your users just intuitively use different words when searching for that item. Using synonyms allows them to access the data even if the term they choose isn’t the same as the actual column name.

You can set column synonyms for columns in tables, user imported data, and worksheets. The returned table or chart uses the actual column name, but the search bar reflects the term the user typed in (the synonym).

To create a synonym for a column:

  1. Find the column for which you want to add synonyms.

  2. Select its Synonyms.

  3. Enter a comma-separated list of the synonyms.

    If a synonym is more than one word, enclose it in double quotes. If you are using the Web interface, you would type:

     profit,"gross profit"

    If you are using the model file, the list of synonyms must be enclosed in square brackets:

     [profit, "gross profit"]
  4. Save your changes.

Was this page helpful?