how to convert a column data into multiple rows

[Former Member]

Hi guys,

i have a requirement like i need to convert one column data into multiple records,

eg:day,sal(these two columns)

sun,10

mon,20

tue ,30

" ,"

i have the above data and i nee to convert like sun,10(one record)

mon,20(another record).

how can i do that in bw modelling please suggest me the way.

Thanks in advance.

ashok

[former_member184494]

Ashok,

Please state your requirement properly ...

eg:day,sal(these two columns)

sun,10

mon,20

tue ,30

this seems like multiple records to me...

Do you mean to say that incoming record is

sun|10|mon|20|tue|30 and you want to convert the same to "

sun|10

mon|20

tue|30

???

Arun

Please confirm if this is what you tried to convey earlier...

[Former Member]

yes ,

thats what i want to say.

please tell me how can i implement that in BW .Please give a clear description.

[Former Member]

Arun,

Did you happen to provide a solution for this? I am also trying to convert one record with multiple columns into multiple records.

ex.

1. Employee | Char 1 | Date 1 | Char 2 | Date 2 | Char 3 | Date 3 |

1. Employee | Char 1 | Date 1 |

2. Employee | Char 2 | Date 2 |

3. Employee | Char 3 | Date 3 |

[neelesh_jain3]

Go for an APD and in the transformation use the process "Transform Data Record into List".

Cheers,

Neel.

[Former Member]

DC,

There are few ways you can create multiple records from one source records.

If you have a factor table to distribute the key figure, you most probably want to use return table in update routine (for 3.X) or write a End-routine in transformation to read the factors and multiplicate the records ( BI 7).

If you don't want to use factor table to mulplicate the records, (like the case you described in your question), you can use key-figure specific update in update rule (3.x) or you can create multiple transformation groups ( BI 7). For your case, probably you want to create 3 transformation groups and create routine for each group.