Hi,
We are loading data to BPC 10.0 through FIM 10.0 the data comes in CSV file.
The data file currently have is in the below format,
Account No | January | Feb | Mar | Apr | May - - - - - - Nov | Dec
ie first column is the account number and against 12 months.
The month value comes in the CSV as and when the date proceeds. What I mean is for February month load I will have only value in the January column. For May month load data will be present till April column.
Now the issue is, we are putting month wise value in to same field in the Target. How can I do the mapping in this case.
I can do the monthwise load by having only one month value ar a time. Is there any option to load all the months at the same time.
Really appreciate your help.
Regards