Skip to Content
0
Dec 08, 2011 at 01:38 PM

using rule groups in transformation

58 Views

Hello, let's say I have a stock data like below:

Material...|....SalesQty.......|......ProductionQty.............|...TransferQty........|.......StockQty

A1..............10.......................................20............................30........................40

A2..............20.......................................30............................40........................50

I want to transform the data like that:

Material....|....movetype.......|.Qty

A1.................stock...............40

A1...............production.........20

A1................transfer............30

A1................sales................10

A2................stock................50

etc..

How to do this operation?

I know that, the inverse operation can be done with rule groups in the transformation...