KNOWLEDGE BASE

Unable to Replace Edit or Group Values Containing "&" (ampersand) in Tableau Prep


Published: 01 Aug 2018
Last Modified Date: 15 Aug 2018

Issue

When using values containing the ampersand character "&", the value cannot be renamed or edited.

Additionally, when using the 'Edit Value' option, the command is recorded as successfully completing in the Changes pane, however the value remains unchanged, and the renamed value not containing the ampersand is shown to be "not present in the data set".

Environment

Tableau Prep 2018.2.1

Resolution

Try one of the following workarounds: 
  1. Use aliases or replace calculated field in Tableau Desktop. 
  2. Use Tableau Prep 2018.2.2.

Cause

This behavior is related to a known issue (ID: 807311) which has been fixed in a recent release of Tableau Prep. 
Did this article resolve the issue?