I have a modelling issue. I have a DSO, which I have to extract data from. The structure of this DSO has 2 records for the same information, the only change is that in the first one I have the Sales in local curr, and in the other I have it in global curr. I mean:
Char1, Char2, Char3, 10 Kg ,100 USD
Char1, Char2, Char3, 10 Kg, 70 EUR
and I would like to have these 2 records combined into one, with separate KFig, just like this.
Char1, Char2, Char3, 10 Kg, 100 USD, 70 EUR
How can I do that?.