Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i have 2 qvd file and i need to join them like the below code.
Table1:
LOAD A1,
B1,
if(not isnull(D1),0,A1) as C1 // D1 Field is in 2nd qvd
FROM
qvd\1.qvd
(qvd) where exists(F1);
Left Join
LOAD D1, E1 FROM qvd\2.qvd (qvd) where exists(E1);
store table1 to table1.qvd;
I'm getting an error field not found. I know D1 field not available in the 1st qvd file.
But i need the C1 field, if D1 is not null.
Could you please give the suggestion?
Hi,
Instead of using Exists you can directly use Inner join instead of left join
Table1:
Load
A1, B1 ,F1
from QVD1 ;
Inner Join(Table1)
Load
D1,E1 ,F1
from QVD2;
Final:
Load *,
If(Not IsNull(D1),0, A1) AS C1
Resident Table1;
Drop Table Table1;
Regards,
Jagan.