top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

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

+1 vote
458 views
Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u achieve using rank transformation ?
posted Oct 30, 2015 by Sachin

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

2 Answers

0 votes

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 Oct 30, 2015 by Manikandan J
0 votes

use Rank and Unique

answer Nov 18, 2015 by Srivijay
...