where not WildMatch()

[EMME_DR]

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;

[marcus_sommer]

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

- Marcus