urgent_ how do i combine two fields and find distinct

[n1ef5ng1]

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

[Anil_Babu_Samineni]

If fields are same, I would ask you to use Rename the fields or Qualify and UnQualify statements in Script

Then, Count({<T1.second_id -= {"=Len(T1.second_id) >0"}>} T1.second_id)

Again, count(TOTAL T2.second_id)

[Anil_Babu_Samineni]

My bad, first one should this?

Count({<T1.second_id -= {' '}>} T1.second_id)