Get File Details - Qlik Community

prees959 · ‎2018-02-14

Hello,

I have a file with the following naming convention :

DailyFileUpload_20171201011506.csv

Is it possible to extract the following into a temp table ::

DailyFileUpload as filename

20171201 as filenamedate

many thanks

Phil

PrashantSangle · ‎2018-02-14

use filename()

mid(subfield(filename(),'_',2),1,8)

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

sunny_talwar · ‎2018-02-14

May be like this

LOAD SubField(FileBaseName(), '_', 1) as filename,

Date#(Left(SubField(FileBaseName(), '_', 2), 8), 'YYYYMMDD') as filenamedate

...

From ....

PrashantSangle · ‎2018-02-14

or left(subfield(filename(),'_',2),8)

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂