Get data from cell value

[Jogi]

Hi guys, 

I have a table with qvd path, and does anybody know how successfully get from cell month and year: 

C:\QlikResource\BI\Application\QVD\Data\2016-10 Products.qvd 

Expected result: 

Year	Month
2016	10

[Arthur_Fong · Accepted solution]

Try this:

load *,SubField(FileName(),'-',1) as FileYear,mid(FileName(),index(FileName(),'-',1)+1,2)as FileMonth from [2016-10 Products.qvd](qvd);

[Brett_Bleess]

Jogi, did Arthur's post get you what you needed?  If so, be sure to give him credit by using the Accept as Solution button on his post, which will also let others know the recommendation did work for the use case too.  If you are still working on things, please leave an update.

Regards,
Brett