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

Avoid Qvd if not present in script??

sunil1989 — Tue, 11 Apr 2017 07:31:39 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??

m_woolf — Tue, 11 Apr 2017 12:13:14 GMT

Set ErrorMode = 0;

Re: Avoid Qvd if not present in script??

Peter_Cammaert — Tue, 11 Apr 2017 12:22:38 GMT

Or use a logic with calls to FileTime() to check whether the two last Qvds really exist. In script code:

Orders:

LOAD * FROM Orders.qvd;

IF Not IsNull(FileTime('Payments.qvd')) THEN

LEFT JOIN Orders LOAD * FROM Payments.qvd;

END IF

IF Not IsNull(FileTime('Refunds.qvd')) THEN

LEFT JOIN Orders LOAD * FROM Refunds.qvd;

END IF

Adjust this technique to whatever specific needs you may have.

Best,

Peter

Re: Avoid Qvd if not present in script??

swuehl — Tue, 11 Apr 2017 12:41:43 GMT

Peter, it seems you accidentally missed the Filetime() usage you wanted to demonstrate:

IF Not IsNull(Filetime('Payments.qvd')) THEN

Re: Avoid Qvd if not present in script??

Peter_Cammaert — Tue, 11 Apr 2017 13:06:02 GMT

True, corrected

Thanks, Stefan !