Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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
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
Hi @Qlikuser09
add the field FileName() as FileName
add one more load and add "where match(FileName , ‘X’, ‘Y’, ‘Z’);