Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlikuser09
Creator II
Creator II

Data load editor remove version files in bulk loading of files

File Names  in the folder :

example

File_202012
File_202001
File_202002

File_202003

File_202003_01

File_202004
File_202005
File_202005_1
File_202005_2

 

I am loading the files as " Load * from [$(vDataDir)/File_202*.xlsx] (ooxml, embedded labels);"

This loads all the files i want to remove the version files and load the remaining 

File_202005_1

File_202005_2

File_202003_01

1 Solution

Accepted Solutions
Or
MVP
MVP

Perhaps something like this would work? Haven't tested it on my end but that's what I'd try:

Where Index(FileName(),'_',2) = 0

 

View solution in original post

2 Replies
Or
MVP
MVP

Perhaps something like this would work? Haven't tested it on my end but that's what I'd try:

Where Index(FileName(),'_',2) = 0

 

MendyS
Partner - Creator III
Partner - Creator III

Hi @Qlikuser09 

add the field FileName() as FileName 
add one more load and add "where match(FileName , ‘X’, ‘Y’, ‘Z’);