how to concat values?

[#1]

this is the box i have:

however, this is the desired output:

So, how to do it?

[#2]

this is the script i have:

I just add" subfield([Purpose_of_Request/fieldvalue],',')     as splitField" ?

[anbu1984]

Yes

[blaise]

I would rather do it in a new table (to avoid duplicating the data) as seen in my code snippet.

Do you know how to user the resident load?

f.ex.

Table:

load

     field1,

     field2

from

     table.qvd

     (qvd)

;

Table2:

load

     field1,

     subfield(field1,',')     as field1split

resident

     Table

;

Resident loads records from an already loaded table.

[#5]

hii,

when ever you want to split a string after a symbol (, . - _ ) then you can use the subfield() function.

In your problem,

you can use it like           subfield('Purpose_of_Request',',').

Hopefully it will work.

Thanks

[#6]

subfield() will split the Purpose_of_Request after the comma.

[sudeepkm]

Please take a look at the attachment. whenever there is a record with two Purpose values like Request,Recovery

in that case two records will be created one with Request and another with Recovery.

Finally there will be only three categories.

[#8]

field1 and field 2 means "recovery and implementation"?