Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

I have requirement to merge the values.

HI

I have requirement to merge the values.

I need to get like below,

Former Member
Former Member replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question