SCRIPT

[sagaraperera]

Dear All

I have two QVD'S

1.SVAT1.QVD

2.SVAT.QVD

in that qvd include AMT1 in SVAT1.QVD and AMT2 in SVAT.QVD. I want to calculate following conditioned in script.Please help me

IF((AMT1+AMT)=>0,N,Y) AS SVAT

THIS FORMULA NOT WORKING. WHAT AMT1 and AMT include differant  QVD'S .How to fix it please help

sagara

[OmarBenSalem]

combine the 2 QVDS in ONE table (depends on how your  data is build)

when you'll have the 2 qvds data in ONE load; then you could execute your condition