Solved: Re: how to validate existence of a qvd - Qlik Community

NatyNu · ‎2024-02-22

Hello, I need to validate the existence of a file before trying to load it so that I don't get an error.
Is there any way to do it?

thank you so much!

FOR Each i IN $(vListaAños) /*2023,2024*/

FOR j =1 to 4

LET vSufijo_qvd = 'T'&j;

/*Cuando busca el COMETH_2024T2.qvd da error porque no existe aun*/

TH_FACTURACION_CONSUMO:

LOAD ....

FROM [lib://QS_GERENCIA/COMETH_$(i)$(vSufijo_qvd).QVD]

(qvd);

....

next j ;

NEXT i ;

marcus_sommer · ‎2024-02-22

You don't need to check the exists of the file else just changing your loop approach by using something like this:

for each file in filelist('lib://.../file_*.qvd')

Clement15 · ‎2024-02-22

anat · ‎2024-02-22

You can use qvdcreatetime function

Let Listqvdexists=isnull(QvdCreateTime('$(VAR_DIR_ETL_QVD)$(VAR_NAME_FILE_QVD).QVD'))

Use below link for incremental load for reference

marcus_sommer · ‎2024-02-22

You don't need to check the exists of the file else just changing your loop approach by using something like this:

for each file in filelist('lib://.../file_*.qvd')

PhanThanhSon · ‎2024-02-22

Hi,

Here's a suggestion:

Simply set the error mode to 0 before your for statement starts,

and set it to 1 when your for statement ends.

Even if the file doesn't exist and you try to load it, you will get an error, but your script will run anyway.

Best regards Son

NatyNu · ‎2024-02-22

You're right!! I'm going to try that. Thank you so much!!

how to validate existence of a qvd