Skip to Content
avatar image
Former Member

I have requirement to merge the values.

HI

I have requirement to merge the values.

I need to get like below,

p1.png (1.6 kB)
p3.png (1.3 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Nov 04, 2015 at 06:31 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

    Add comment
    10|10000 characters needed characters exceeded