Skip to Content
0
Former Member
Jan 20, 2012 at 10:24 AM

Flat file format for FIM 10.0 dataload

29 Views

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