2 Replies Latest reply: Sep 25, 2017 6:12 AM by Anil Babu RSS

    urgent_ how do i combine two fields and find distinct

    ben lim

      Hi all ,

       

      I have this two field names call first_user_ID and second_user_ID. do note that I cant do in script level due to complexity on this.

       

      I would want to find out the # of distinct user based on the two fields.

       

      how can i script in a way to find the expected output as below. basically is to concatenate second_id to first_id and find the distinct. however i have to do in expression level.

       

      i.e

       

      Capture.PNG