Creating calendar with time file

[#1]

Hi everyone,

I have got datas from differents files. Each files matches for one months. The fiels are identicals. I want to concatenate these table and create a calendar. The problem is that the date is in the title. Does it possible to extract this date in QlikView and match it for each tables?

Thanks you very much

[stevietm]

Do you have an example of the files you are using?

[#3]

There is a screen shot of one of my files it's for april 2014. The date is in the header ( 2014 and 'Avril') I've this kind of files for each month. Thank you for your help