2 Replies Latest reply: Sep 25, 2017 6:12 AM by Anil Samineni 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.