Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

Extracting file attributes from a target database

Hi All,

Please assist me. I've recently started coding with Qlikview. I am looking for code to extract file attributes from a target database. I want to extract the file name, path, extension etc. Where can I find such a code?

Thanks.

Regards

Ziyanda.

1 Reply

Re: Extracting file attributes from a target database

Something like this:

LOAD MyField,

     subfield(MyField, '.', -1) as extension,

     mid(MyField, index(MyField, '\',-1)+1, index(MyField,'.',-1)-index(MyField,'\',-1)-1) as file_name,

     left(MyField, index(MyField,'\',-1)) as path

FROM ...


talk is cheap, supply exceeds demand
Community Browser