Skip to Content
avatar image
Former Member

Merge values

HI

I have requirement to merge the values.

Dataset,

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

5 Answers

  • Nov 03, 2015 at 02:35 PM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 03, 2015 at 02:36 PM

    Instead of priority, use:

    =[priority]+Previous(Self;([Name]))

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 03, 2015 at 08:03 PM

    Hariharan,

    You can follow the below link for a simpler approach at universe level to achieve the same.

    How to display column values in a single cell in Web Intelligence using Oracle database ? | Irfan's World

    Regards

    Sri Harsha

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 03, 2015 at 10:01 PM

    Hi,

    You can refer my blog.

    String aggregation on WEBI report level.

    Thanks,

    Swapnil

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 04, 2015 at 04:47 AM

    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

    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