Skip to Content
0
Former Member
Oct 11, 2011 at 01:50 PM

RPSCO table in PS

162 Views

Hi,

I have created a generic extractor on top of RPSCO table.

In RPSCO table the amt field is splited into 16 columns based on period WLP00, WLP01,...to.... WLP16.

Eg., WL00 Wl01 WL02 WL03.... WL16

200 300 400 500

In BI, I want data in two columns period and amount.

Period Amount

01 200

02 300

03 400

04 500

Please suggets how can i achieve it..