Multiple rows to single row

[#1]

Hi,

i have callno and partno and many other fields also which i have loaded in straight table. for a single call no we have multiple partnos which i want to load in a single column and row with inserting a separator how can this be done?

sample:

callno - 2349

partnos-

XXX

rtgh

UUUU

result i want it as :

callno      |   partnos

2349       |    XXX, rtgh, UUUU

Regards,

Grace

[#2 · Accepted solution]

Load callno, concat(partnos,',') as Allpartnos from tablename

group by callno;

since u've other fields also, u need to group by those fields also

or u can only use this part in a separate load and link to the main table.

depends on which cols u need in ur stght table

[#3]

Thanks, how to do vice versa...

partno

XXX, rtgh, UUUU

i want to load one below the other...

[#4]

what do u mean by one below the other, aren't they already one below the other ?

[nagaiank]

Use SubField() as shown below:

LOAD SubField(partno,',') as IndividualPartNo

from/resident whatever...