8 Replies Latest reply on Mar 31, 2014 4:55 AM by Anthony Macey

    Why is my string generating a bad character?

    Anthony Macey

      Hello all,

       

      I am writing a filter to map certain categories to specified values using;

       

      IF [MEASURE] = 'X Value' then 'X'

      ELSEIF [MEASURE] = 'Y Value' then 'Y'

       

      However the data source I am using has an ampersand in one of the strings and it is throwing up a Bad Character error.

       

      Does anybody have any idea why as I thought the information contained within the string was just treated as text.

       

      NB. I do not know if it's important but I mapped this in Excel and then pasted in to Notepad to make it plain text before copying in to Tableau.

       

      Many thanks.

       

      EDIT: Not sure if it was clear above but the error looks like;

       

      ELSEIF [MEASURE] = 'Z & Value' then 'Z'