Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Multiple file import

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

1 Solution

Accepted Solutions
MarcoWedel

LOAD *

FROM [<path>\RESULT_*.*]

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

View solution in original post

3 Replies
MarcoWedel

LOAD *

FROM [<path>\RESULT_*.*]

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

Not applicable
Author

Thanks Marco it worked:)

Anonymous
Not applicable
Author


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