Appending Date

[mansi_dv]

I have an excel document from which I load my data. But the excel sheet has contents as below:

Document Name:

Execution Date:

Execution Time:

:

:

:

etcetra

and then I have the actual data wihich I want to load.

Now, I remove all the above data in the [File Wizard: Type] and keep only the table. But the issue is, I want to append the year, Quarter and month from the above mentioned date in my script. Is it possible?

[sundarakumar]

U should have a date field anywhere in the data, but u have specified an inerval for the data...

Does all the data shown here fall under the july2012 to aug 2012.?

-Sundar

[#3]

I build an example how I understand your issue.

[mansi_dv]

Ya but I need the aug 2012 part...ie I want to append 'august' as month, '2012' as year and 'Q2' as quarter.

[sundarakumar]

If all the data are going to ahve aug 2012 and Q2 then u can do it as

load,

field1,

field1,

2012 as year,

'Aug' as month,

'Q2' as quarter

from

table.xls;

-Sundar

[mansi_dv]

Ya I have done this only Sundarakumar, but went the app will be given to the client, more and more monthly data will be added...all such data should be dynamically appended in the files. So I need a method to do that.

[sundarakumar]

What do u expect the data source to be? excel fiels? how often will u get them?

Will u get it in a certain interval of time?

will the files be in the same format or will it have the same fields?

-Sundar

[mansi_dv]

ya data source will be excel files and can be given any time so I need to append date from the period part.

All the files will be in the similar format.

[#9]

Hi,

Check the attached one