topic Re: Multiple file import in QlikView

Multiple file import

Thu, 06 Nov 2014 10:22:17 GMT

Hi there, I'm struggling to import a specific range of files into my Qlikview App. See attached file.

I have a folder with multiple result files. I only need to import files from 'RESULT_0000000117_79120' onwards. My challenge is I'll have to do this without changing the file name or creating a separate folder. The following file is ....118_... , ....119_... etc.

Please assist. Thanks

Re: Multiple file import

MarcoWedel — Thu, 06 Nov 2014 11:37:26 GMT

LOAD *

FROM [<path>\RESULT_*.*]

WHERE Subfield(FileBaseName(), '_', 2) >= 117;

Re: Multiple file import

Thu, 06 Nov 2014 12:21:53 GMT

Thanks Marco it worked:)

Re: Multiple file import

Anonymous — Thu, 06 Nov 2014 13:59:23 GMT

Can you please explain about filed value, why you have given 2.