cancel
Showing results for 
Search instead for 
Did you mean: 

Merge values

Former Member
0 Kudos

HI

I have requirement to merge the values.

Dataset,

I need to get like below,

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

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
Former Member
0 Kudos

Hi,

You can refer my blog.

Thanks,

Swapnil

Former Member
0 Kudos

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&am...

Regards

Sri Harsha

Former Member
0 Kudos

Instead of priority, use:

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

Former Member
0 Kudos

Hi

Am getting #Multivalue error.

Thanks

Hari

amitrathi239
Active Contributor
0 Kudos