6 Replies Latest reply on May 18, 2018 9:57 PM by David Maning

    Create new variable with string values from existing variable

    roberta.demichele.687

      Hello!

      just registered on this amazing community, I started learning Tableau a couple of months ago and still I struggle with some things.

      I ask for your help with this variable (see file attached) which has nearly 74 values of Italian provinces and my desired output is a new variable that somehow groups them in 3 categories (north, center, south) so basically I think I need something like

      if [existing var] = 'value1' or 'value2' .. 'valuen' then 'NORTH'

      and the same for Center and South.

      I've tried with IF syntax and WHEN syntax but there's something I'm missing cause it gives me various errors.

      How should I calculated this?