Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

LOAD *

FROM [<path>\RESULT_*.*]

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

View solution in original post

3 Replies
Highlighted

LOAD *

FROM [<path>\RESULT_*.*]

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

View solution in original post

Highlighted
Not applicable

Thanks Marco it worked:)

Highlighted
Contributor III
Contributor III


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