KNOWLEDGE BASE

When Connected to SharePoint, Fields Containing Multiple Values Are Displayed with The Values Separated by ";#" Delimiter


Published: 14 Jun 2022
Last Modified Date: 08 Jul 2022

Issue

When connected to SharePoint, quick filter fields containing multiple values are displayed with the values with ";#" delimiters on Tableau Desktop.

Environment

  • Tableau Desktop
  • SharePoint

Resolution

Use REPLACE() function and replace ";#" to another string you like.
To convert it to ", (comma)", add a calculated field and enter a formula like the following.
REPLACE( [target field], ";#", ",")

 

Cause

In SharePoint, when multiple values are registered in one field, even if they are separated by ", (comma)" in the GUI, they are registered in the database with ";#" as a delimiter.
Did this article resolve the issue?