Skip to Content
0
Former Member
Apr 15, 2010 at 08:01 AM

Flatfile Upload-Issue

26 Views

Hi,

I have a flatfile which has to be loaded daily.

In this flatfile there are two columns corresponding to time characteristics. one is calender month and the other calendar day.

Trasactional data never changes and everyday i need to change the day values to todays date and need to upload to BI system.

and if the month changes then i need to change the month (and day ofocurse) and do the upload again.

is there any autmozing process for conversion of these day values to todays value before uploadig?