on 11-04-2015 6:27 AM
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 |
then create a second Variable2="[XXX]+","+Previous(Self)"
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, |
create the third ="=[variable2] Where( [XXX]=[var_Max])"
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, |
create another
variable3 ="If(IsNull(Previous([var_Max]));Substr([self+var_max];1;Length([self+var_max])-2);
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 |
Thanks and Regards
DInesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.