Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I come across I problem I don't understand:
In my data load editor, I have table1 with fields A, B, table2 with fields A, C. My script is:
TABLE:
SELECT A, B FROM table1;
LEFT JOIN (TABLE)
SELECT A, C FROM table2;
LOAD A,B,C RESIDENT TABLE;
But everything is duplicated. If I remove the LOAD, everything is correct. I don't quite understand why. Any idea? Is there any reference regarding this?
Thanks for help!
TABLE:
SQL SELECT A, B FROM table1;
LEFT JOIN (TABLE)
SQL SELECT A, C FROM table2;
final:
noconcatenate LOAD A,B,C RESIDENT TABLE;
drop table TABLE;