Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
mansi_dv
Contributor
Contributor

Appending Date

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?

17 Replies
sundarakumar
Specialist II
Specialist II

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

Not applicable

I build an example how I understand your issue.

mansi_dv
Contributor
Contributor
Author

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

sundarakumar
Specialist II
Specialist II

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
Contributor
Contributor
Author

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
Specialist II
Specialist II

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
Contributor
Contributor
Author

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.

Not applicable

Hi,

Check the attached one