on 11-03-2015 2:31 PM
hi Rajendran,
create variable ="Max([XXX]) In( [Name])" u will see
Name | XXX | var_Max |
---|---|---|
A | p1 | p3 |
A | p2 | p3 |
A | p3 | p3 |
B | p4 | p7 |
B | p5 | p7 |
B | p6 | p7 |
B | p7 | p7 |
c | p10 | p9 |
c | p11 | p9 |
c | p8 | p9 |
c | p9 | p9 |
Name | XXX | var_Max | self |
---|---|---|---|
A | p1 | p3 | p1, |
A | p2 | p3 | p2,p1, |
A | p3 | p3 | p3,p2,p1, |
B | p4 | p7 | p4,p3,p2,p1, |
B | p5 | p7 | p5,p4,p3,p2,p1, |
B | p6 | p7 | p6,p5,p4,p3,p2,p1, |
B | p7 | p7 | p7,p6,p5,p4,p3,p2,p1, |
c | p10 | p9 | p10,p7,p6,p5,p4,p3,p2,p1, |
c | p11 | p9 | p11,p10,p7,p6,p5,p4,p3,p2,p1, |
c | p8 | p9 | p8,p11,p10,p7,p6,p5,p4,p3,p2,p1, |
c | p9 | p9 | p9,p8,p11,p10,p7,p6,p5,p4,p3,p2,p1, |
Name | XXX | var_Max | varable 2 | self+var_max |
---|---|---|---|---|
A | p1 | p3 | p1, | p3,p2,p1, |
A | p2 | p3 | p2,p1, | p3,p2,p1, |
A | p3 | p3 | p3,p2,p1, | p3,p2,p1, |
B | p4 | p7 | p4,p3,p2,p1, | p7,p6,p5,p4,p3,p2,p1, |
B | p5 | p7 | p5,p4,p3,p2,p1, | p7,p6,p5,p4,p3,p2,p1, |
B | p6 | p7 | p6,p5,p4,p3,p2,p1, | p7,p6,p5,p4,p3,p2,p1, |
B | p7 | p7 | p7,p6,p5,p4,p3,p2,p1, | p7,p6,p5,p4,p3,p2,p1, |
c | p10 | p9 | p10,p7,p6,p5,p4,p3,p2,p1, | p9,p8,p11,p10,p7,p6,p5,p4,p3,p2,p1, |
c | p11 | p9 | p11,p10,p7,p6,p5,p4,p3,p2,p1, | p9,p8,p11,p10,p7,p6,p5,p4,p3,p2,p1, |
c | p8 | p9 | p8,p11,p10,p7,p6,p5,p4,p3,p2,p1, | p9,p8,p11,p10,p7,p6,p5,p4,p3,p2,p1, |
c | p9 | p9 | p9,p8,p11,p10,p7,p6,p5,p4,p3,p2,p1, | p9,p8,p11,p10,p7,p6,p5,p4,p3,p2,p1, |
Substr([self+var_max];1;Pos([self+var_max];Previous([self+var_max]))-2))"
Name | XXX | var_Max | varable 2 | self+var_max | zzz |
---|---|---|---|---|---|
A | p1 | p3 | p1, | p3,p2,p1, | p3,p2,p |
A | p2 | p3 | p2,p1, | p3,p2,p1, | |
A | p3 | p3 | p3,p2,p1, | p3,p2,p1, | |
B | p4 | p7 | p4,p3,p2,p1, | p7,p6,p5,p4,p3,p2,p1, | p7,p6,p5,p4 |
B | p5 | p7 | p5,p4,p3,p2,p1, | p7,p6,p5,p4,p3,p2,p1, | |
B | p6 | p7 | p6,p5,p4,p3,p2,p1, | p7,p6,p5,p4,p3,p2,p1, | |
B | p7 | p7 | p7,p6,p5,p4,p3,p2,p1, | p7,p6,p5,p4,p3,p2,p1, | |
c | p10 | p9 | p10,p7,p6,p5,p4,p3,p2,p1, | p9,p8,p11,p10,p7,p6,p5,p4,p3,p2,p1, | p9,p8,p11,p10 |
c | p11 | p9 | p11,p10,p7,p6,p5,p4,p3,p2,p1, | p9,p8,p11,p10,p7,p6,p5,p4,p3,p2,p1, | |
c | p8 | p9 | p8,p11,p10,p7,p6,p5,p4,p3,p2,p1, | p9,p8,p11,p10,p7,p6,p5,p4,p3,p2,p1, | |
c | p9 | p9 | p9,p8,p11,p10,p7,p6,p5,p4,p3,p2,p1, | p9,p8,p11,p10,p7,p6,p5,p4,p3,p2,p1, |
remove all object Except Name and variable3
fanlly u can seethis view
Name | zzz |
---|---|
A | p3,p2,p |
B | p7,p6,p5,p4 |
c | p9,p8,p11,p10 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hariharan,
You can follow the below link for a simpler approach at universe level to achieve the same.
Regards
Sri Harsha
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Instead of priority, use:
=[priority]+Previous(Self;([Name]))
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.