10 Replies Latest reply: Apr 3, 2018 2:48 PM by Sasidhar Parupudi RSS

    data load editor: select & load

    Wanyun Yang

      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!