Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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’);