topic Re: Replace file path with wildcard in QlikView

Replace file path with wildcard

DataKnight1 — Wed, 12 May 2021 10:28:10 GMT

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

Re: Replace file path with wildcard

Gysbert_Wassenaar — Wed, 12 May 2021 16:24:18 GMT

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.

Re: Replace file path with wildcard

PadmaPriya — Wed, 12 May 2021 18:43:54 GMT

Hello @DataKnight1

Please refer to below article:

https://community.qlik.com/t5/Knowledge-Base/How-to-use-wildcards-when-creating-exclusions-on-Antivirus/ta-p/1807463

Thanks,

Padma Priya