Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Please help in the below scenario:
Load A1,A2,A3 from A
I want to load B in such a manner -
Load B1,B2,B3 from B where B1 = A1
I tried the above way but it is showing A1 column not found.
Please help how to achieve the above.
Thanks,
Girish Inani
May be use Where Exist here:
LOAD A1,
A2,
A3
FROM A;
LOAD B1,
B2,
B3
FROM B
Where Exists(A1, B1);