3 Replies Latest reply: Dec 1, 2016 7:51 AM by Stefan Wühl RSS

    How to get single distinct value from two columns in expression

    sreeranga prasad

      hi

      my requirement to get distinct value from two columns. i need this in dimension expression

       

      lets say my data rows will be look like this

       

      IdOriginstateDestinationSate
      1PAVA
      2PATX
      3
      TX
      NY
      4FLMA

       

      Finally i need data look like below as single value in expression

      ex:

      state
      PA
      VA
      TX
      NY
      FL
      MA

       

      please advise me how to get this