topic Re: Avoid Qvd if not present in script?? in QlikView

Avoid Qvd if not present in script??

sunil1989 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Avoid Qvd if not present in script??

tunoi — Tue, 11 Apr 2017 07:40:49 GMT

easiest metod is to use errormode switch

set errormode = 0;

orders

join

payment

join

Refund

set errormode = 1;

Re: Avoid Qvd if not present in script??

quwok — Tue, 11 Apr 2017 09:39:41 GMT

Another common solution would be to check for the QVD timestamp

How can I check if a file exists ?

Re: Avoid Qvd if not present in script??

Siva_Sankar — Tue, 11 Apr 2017 09:55:06 GMT

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