Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Given the following INPUT and OUTPUT sample, what is the right script to do it?
Thank you !
Hello,
Try to use Where clause with Exists() function... Something like this:
Table1:
LOAD ID
, Field1
from .....
Table2:
LOAD
ID-Cusomer
, Field2
, Field3
From ....
Where Exists(ID-Customer,ID);
Hope this helps you.
Regards,
Andrei
Table1:
LOAD ID
, Field1
from .....
Table2:
LOAD
ID-Cusomer
, Field2
, Field3
From ....
Where Exists(ID,ID-Customer);
Sorry for misprint.
Yes, of course Where Exists(ID,ID-Customer); is correct.
Thanks for correction.
Andrei