Multi-period multi-column data load using BIP
I want to load multi-column multi-period data from the BIP report, in the report, the headers are like BUCKET_AMOUNT7 BUCKET_AMOUNT8 BUCKET_AMOUNT9 BUCKET_AMOUNT10 BUCKET_AMOUNT11 BUCKET_AMOUNT12
let's say I want to load Nov-24 to Mar-25 then BUCKET_AMOUNT9 should go to nov-24, BUCKET_AMOUNT10 to dec-24, and BUCKET_AMOUNT11 to jan-25 and like that .
My question is how to map these columns to the period. Any suggestions would be helpful. Thanks in advance.
Tagged:
0