topic Re: How to fetch file name? in QlikView

How to fetch file name?

soha1902 — Wed, 09 Jul 2014 06:31:18 GMT

Hello everyone,

I want to load file name in my QV app.

for example: I am having below URL list in excel.

URL

\\abc.com\project\docs\cs\one.xlsx

\\abc.com\prjocts\docs\cs\it\two.xlsx

\\abc.com\prjocts\cs\it\three.xlsx

Now I want to load only last name in my app like below

URL

one.xlsx

two.xlsx

three.xlsx

Please help.

Re: How to fetch file name?

its_anandrjs — Wed, 09 Jul 2014 06:34:51 GMT

Use subfield function

Re: How to fetch file name?

its_anandrjs — Wed, 09 Jul 2014 06:37:41 GMT

Try Like

LOAD URL, SubField(URL,'\',-1) AS NewUrl

LOAD * Inline

[

URL

\\abc.com\project\docs\cs\one.xlsx

\\abc.com\prjocts\docs\cs\it\two.xlsx

\\abc.com\prjocts\cs\it\three.xlsx

];

Re: How to fetch file name?

Wed, 09 Jul 2014 06:43:22 GMT

Hi soha,

You need to use FileBaseName() for this in script level like,

FileBaseName() as BaseName

Re: How to fetch file name?

amit_saini — Wed, 09 Jul 2014 06:50:44 GMT

Hi Soha,

Like this??? Please see the attachment.

Thanks,

AS