Essentially I am trying to build a template where you could drop image files and they will display by looking up certain named files and place them in the right place. Then I call the image in a text object like '$(vLogoFile)'. Right now it works for any image as long as it is a .jpg, but the pull doesn't recognize .png or .gif files.
So i didnt think i need to bundle the actual images just look up and reference the names and paths, but do you think bundling would give better results?
FileBaseName() as BaseName,
FileName() as ImageFile,
FileExtension() as Extension
LET vLogoFile = lookup('ImageFile', 'BaseName','TitleBarImage');
Can't reproduce your issue, using your code I get a lot of file extensions:
You can also consider using FOR EACH file in FILELIST instead of the wildcard search in the FROM.
How may rows did you get? Wen I try your code against a folder with 22 files, I get all extensions -- but 36K rows. The default format spec is "(txt)" so each file may generate multiple rows whilst the LOAD is searching for newline chars.
In your case of the missing files, I'll bet something that looked like an EOF was encountered before any "row" was read.
In any case, your hunch is right. This is not a valid technique to collect filenames from a directory. For that, use FOR EACH IN FILELIST() as you suggested.
Any idea why i would get not get results for all the functions ( I think they are valid QV functions):
FOR Each File in filelist ('D:\QlikView\Images\*')
'$(File)' as Name,
FileSize( '$(File)' ) as Size,
FileTime( '$(File)' ) as FileTime,
FileBaseName( '$(File)' ) as BaseName,
FileName( '$(File)' ) as ImageFile,
FileExtension( '$(File)' ) as Extension