topic Re: Extrat Date from QVD file name in QlikView

Extrat Date from QVD file name

New-Qlik — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I want to extract and save date from QVD file name eg

Sales_20180101.qvd

Sales_20180102.qvd

i want a date column having dates like 20180101 and 20180102 and is link with data in corresponding QVDs

TIA

Re: Extrat Date from QVD file name

Vegar — Wed, 13 Nov 2019 13:04:55 GMT

You can use FileBaseName() to fetch the file base name, subfield() to fetch the integer representing the date and date#() to intepret the integer. Dayname() is used just for the correct presentation of your date.

LOAD
*,
DayName( date#( subfield(FileBaseName() , '_',2),'YYYYMMDD' ))as FileDate

FROM *.QVD (qvd);

Re: Extrat Date from QVD file name

m_woolf — Wed, 13 Nov 2019 13:02:29 GMT

Something like:

date(textbetween(<QVDFileName>,'_','.'),'YYYYMMDD') as QVD_Date;

Re: Extrat Date from QVD file name

Brett_Bleess — Mon, 18 Nov 2019 18:34:25 GMT

Avneet, did Vegar or Mike's posts help you get things working? If so, be sure to come back to the thread and use the Accept as solution button on the post that worked best for you to give them credit for the help and let other Community Members know which worked best for your use case. If you are still working on things, please leave an update.

Regards,
Brett

Re: Extrat Date from QVD file name

New-Qlik — Tue, 19 Nov 2019 07:55:59 GMT

Actually both of them are right. Thanks for reminding.