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...