topic Return Folder Name as field in QlikView

Return Folder Name as field

renjithpl — Fri, 07 Jan 2011 07:40:44 GMT

Hi all,

Filebasename() returns file name, Is there a way to get folder name like that.

I tried Filedir() but that gives the whole directory.

THanks in advance.

Fri, 07 Jan 2011 08:56:57 GMT

Hi,

See the 'Photo and Music' sample from Start Page

subfield(FileLongName,'\',substringcount(FileLongName,'\')) as [Photo Directory]

Regards,

Andris

Fri, 07 Jan 2011 09:13:47 GMT

Hi,

try to use the following script lines:

Load *,
Subfield(Dir,'\', NumberOfTimes + 1) as FolderName;
LOAD
FileDir() as Dir,
substringcount(FileDir(),'\') as NumberOfTimes

Good luck!

Rainer