topic Re: How to Restrict some files while loading into qlikview based on File Extensions in QlikView

How to Restrict some files while loading into qlikview based on File Extensions

Anonymous — Wed, 30 Oct 2013 10:57:09 GMT

Hi Guys,

I have a column that having Filenames. My issue is when i load that field into qlikview, i want to restrict some files based on the file extensions(eg: .jpg, .jpeg..). How can i do this?

Please help me on this issue.

Thanks

Re: How to Restrict some files while loading into qlikview based on File Extensions

swuehl — Wed, 30 Oct 2013 11:04:39 GMT

Maybe using a WHERE clause with a match condition:

LOAD

Filenames

FROM Table.xls WHERE match(right(Filenames,4),'.jpg','jpeg','.png');

..WHERE match(subfield(Filenames,'.',-1),'jpg','jpeg','png');

Re: How to Restrict some files while loading into qlikview based on File Extensions

Anonymous — Wed, 30 Oct 2013 11:38:20 GMT

Here you are loading the files based on extensions, but i want to restrict those files into qlikview

Re: How to Restrict some files while loading into qlikview based on File Extensions

sujeetsingh — Wed, 30 Oct 2013 11:42:06 GMT

Man then only add those extension in where clause which you want

Re: How to Restrict some files while loading into qlikview based on File Extensions

Wed, 30 Oct 2013 11:54:37 GMT

Hi Pradeep,

You can use SubField function there. I am including a sample code that may help you.

IMG_LOAD:

LOAD ID, FILE_NAME INLINE [

ID, FILE_NAME

2, test.jpg

3, test.jpeg

4, no.png

5, yes.png

6, khan.bmp

7, key.jpg

]

where match(SubField(FILE_NAME, '.', -1),'jpg');

And for not loading some file name with extension you can use below WHERE clause:

where if(match(SubField(FILE_NAME, '.', -1),'jpg','jpeg'),0,1);

It'll load the records which contain neither jpg nor jpeg