Multiple file import

[#1]

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

[MarcoWedel · Accepted solution]

LOAD *

FROM [<path>\RESULT_*.*]

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

[#3]

Thanks Marco it worked:)

[Anonymous]

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