Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
sunil1989
Contributor
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
Creator
Creator

easiest metod is to use errormode switch

set errormode = 0;

orders

join

payment

join

Refund

set errormode = 1;

quwok
Creator III
Creator III

Another common solution would be to check for the QVD timestamp

How can I check if a file exists ?

Siva_Sankar
Master II
Master II

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