Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u achieve using rank transformation ?

Question

During the bench mark Drive test with other operator, we observe that in my network Rank 2 distribution is only 30% while in other operator is 60%.

can you help me what can be the possible causes for this?

Answer 1

From source qualifier map the column(id) into two fields of
rank (id,id_grp). select grp_id as group by and rank as 1

output should be

1
2
3

Answer 2

use Rank and Unique