topic Re: how to validate existence of a qvd in App Development

how to validate existence of a qvd

NatyNu — Thu, 22 Feb 2024 13:29:34 GMT

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 ;

Clement15 — Thu, 22 Feb 2024 13:50:10 GMT

anat — Thu, 22 Feb 2024 14:10:53 GMT

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 — Thu, 22 Feb 2024 16:34:59 GMT

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 — Thu, 22 Feb 2024 19:51:24 GMT

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 — Thu, 22 Feb 2024 19:15:00 GMT

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