Replace file path with wildcard

[DataKnight1]

Hi,

Does anyone know if it is possible to replace part of a file path with wildcard?

Eg;

If I had several files I wanted to read from each of the below;

..\2018 - Archive\

..\2019 - Archive\

..\2020 - Archive\

I could replace with something like;

..\2018*\

..\2019*\

..\2020*\

I'm aware this works when reading a document, but it's the file path I'm asking about.

Thanks all

[Gysbert_Wassenaar]

Not as far as I know. I reckon you need to loop through the results of a Dirlist('somepathhere') and then check if the dirname contains the pattern you want and then do further processing.

[PadmaPriya]

Hello @DataKnight1 

Please refer to below article:

https://community.qlik.com/t5/Knowledge-Base/How-to-use-wildcards-when-creating-exclusions-on-Antivi...

Thanks,

Padma Priya