3 Replies Latest reply on Feb 15, 2012 8:15 PM by Shawn Wallwork

    how to concatenate string fields?

    Leah Macfadyen

      Inspired by today's online training an calculations, I'm trying to work with my data. What I want to do *appears* quite simple. I have two string dimensions fields, and I want to concatenate them into a single string dimension. They're actually 'course subject' and 'course number'.

       

      So, I currently have eg 'course subject dimension' = SOCI, 'course number dimension' = 430, and I really want a new dimension called, say 'course title' = SOCI 430.

       

      Reading the forums, I've tried to create a new calculated field using: str([course subject]) + "  " + str([course number])...but it's not working.

       

      Thanks for any help...