Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

sunil1989
New Contributor

Avoid Qvd if not present in script??

Hi ,

Thanks in advance.

I have three QVD of three tables i.e.orders, payment and refunds.

And in my main Transformation qvd i am doing full outer join of this three table.

orders

join

payment

join

Refund

suppose if payment qvd vice versa is not presnt then script get failed , my requirement is if payment qvd is not presnt then also script  should run with

orders

join

Payment.

Thanks,

Sunilkumar

3 Replies
tunoi
Contributor

Re: Avoid Qvd if not present in script??

easiest metod is to use errormode switch

set errormode = 0;

orders

join

payment

join

Refund

set errormode = 1;

Highlighted
quwok
Contributor III

Re: Avoid Qvd if not present in script??

Another common solution would be to check for the QVD timestamp

How can I check if a file exists ?

Siva_Sankar
Honored Contributor

Re: Avoid Qvd if not present in script??

Hi Sunil,

Same is discussed here Command to check if a QVD file exists How can I check if a file exists ?

It may help you.

Siva