topic Re: where not WildMatch() in App Development

where not WildMatch()

EMME_DR — Fri, 18 Mar 2022 15:24:12 GMT

Hi,

in the editor i try to extract only files csv that doesn't contain the word 'ElencoFlussi', but it fails: what can I do?

Regards.

PDR_STG1:
LOAD
Piva_Udb&'|'&Cod_Remi&'|'&Cod_prof_prel_std&'|'&Trattamento&'|'&Annomese&'|'&pdr as key,
pdr&'|'&Annomese as key_flussi,
pdr,
Prelievo,
Piva_Udb,
Dtg,
Cod_Remi,
Id_regione_climatica,
Cod_prof_prel_std,
Trattamento,
Tipo_cliente,
Sessione,
Annomese,
filename() as NomeFile
FROM [lib://SCR_Shared_Folder/Dettaglio PDR - Flussi/*.csv]
(txt, codepage is 28591, embedded labels, delimiter is ';', msq)
where not WildMatch(filename(), 'ElencoFlussi');

exit script;

Re: where not WildMatch()

AshutoshBhumkar — Fri, 18 Mar 2022 17:03:39 GMT

Hello,

Try below,

where not WildMatch(filename(), '*ElencoFlussi*');

Thanks,
Ashutosh

Re: where not WildMatch()

EMME_DR — Fri, 18 Mar 2022 21:56:15 GMT

No, it extracts all files

Re: where not WildMatch()

marcus_sommer — Mon, 21 Mar 2022 11:12:44 GMT

I'm not sure if you could use filename() on the outside of a load - means it's probably empty or NULL.

More suitable within the many scenarios is the use of filelist() instead of your wildcard-load - means something like:

for each file in filelist('path\*.csv')
if not wildmatch('$(file)', '*xyz*') then
... load ...
end if
next

- Marcus

Re: where not WildMatch()

EMME_DR — Mon, 21 Mar 2022 11:37:15 GMT

what do i set in the 'Set' condition before the loop?

Re: where not WildMatch()

marcus_sommer — Mon, 21 Mar 2022 12:34:47 GMT

I think you mean this:

for each file in filelist('path\*.csv')
if not wildmatch('$(file)', '*xyz*') then
t: load * from [$(file)] (txt, ...);
end if
next

- Marcus

Re: where not WildMatch()

EMME_DR — Mon, 21 Mar 2022 14:13:15 GMT

Nope Marcus, the script reads all file and don't exclude the files 'Elenco Flussi'.

Re: where not WildMatch()

marcus_sommer — Mon, 21 Mar 2022 14:31:29 GMT

You use it really like above suggested with load * from [$(file)] and replacing xyz with your string? You may also adjust a bit the condition from:

if not wildmatch('$(file)', '*xyz*') then

if wildmatch('$(file)', '*xyz*') = 0 then

- Marcus

Re: where not WildMatch()

durgesh22 — Mon, 21 Mar 2022 14:34:58 GMT

Code give above worked for me,, made it more simplified ,try it.Hope it works for you

for each file in filelist('MENTION PATH HERE\*.csv')
if not wildmatch('$(file)', '*Elenco Flussi*') then
t: load * from [$(file)] (txt);
end if
next

Re: where not WildMatch()

EMME_DR — Mon, 21 Mar 2022 15:54:15 GMT

Yes, i replace with the correct info.
I try with your second option but I've the same error:

Caricamento dati iniziato
xxx_yyy_AGG_S1_FIN_202001_20211129124442_1 Linee recuperate: 502 02698620347_01219980529_AGG_S1_FIN_202001_20211129124442_1 << xxx_yyy_AGG_S1_FIN_202002_20211129124442_1 Linee recuperate: 999 02698620347_01219980529_AGG_S1_FIN_202001_20211129124442_1 << xxx_yyy_AGG_S1_FIN_202003_20211129124442_1 Linee recuperate: 1.492 02698620347_01219980529_AGG_S1_FIN_202001_20211129124442_1 << xxx_yyy_AGG_S1_FIN_202004_20211129124442_1 Linee recuperate: 1.980
Si è verificato il seguente errore:
Field 'Piva_Udb' not found
L'errore si è verificato qui:
LOAD Piva_Udb&'|'&Cod_Remi&'|'&Cod_prof_prel_std&'|'&Trattamento&'|'&Annomese&'|'&pdr as key, pdr&'|'&Annomese as key_flussi, pdr, Prelievo, Piva_Udb, Dtg, Cod_Remi, Id_regione_climatica, Cod_prof_prel_std, Trattamento, Tipo_cliente, Sessione, Annomese, filename() as NomeFile FROM [lib://SCR_Shared_Folder/Dettaglio PDR - Flussi/*.csv] (txt, codepage is 28591, embedded labels, delimiter is ';', msq)
I dati sono stati caricati. Correggere l'errore e riprovare a caricare.

If you read the error message, qlik is able to load files but stops when it finds files '*Elenco Flussi*'

When you read 'Field 'Piva_Udb' not found' it's because the paths the 2 type of files are different

Re: where not WildMatch()

marcus_sommer — Mon, 21 Mar 2022 17:42:29 GMT

What you did is not equally to my suggestion. Please follow it more closely.

- Marcus