topic Re: Data load editor remove version files in bulk loading of files in App Development

Data load editor remove version files in bulk loading of files

Qlikuser09 — Wed, 14 Dec 2022 15:24:05 GMT

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

Or — Wed, 14 Dec 2022 15:31:27 GMT

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 — Wed, 14 Dec 2022 15:34:44 GMT

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