2 Replies Latest reply: Dec 4, 2015 1:06 PM by Andy Faulkner RSS

    table concatenate creates two tables


      Im trying to concatenate the tables below (actually the same table with different filters)

      I expect to see myNewTable columns only, however instead I see myNewTable and myNewTable-1.

      Can someone explain how I can achieve having myNewTable only?

      Thank you,



      LOAD * Resident table1 WHERE (not Match(myType,'SCR') and not Match(myStatus,'95','85','86','25')) or (Match(myType,'SCR') and match(myValue,'FLM'));
      LOAD * Resident table1 WHERE  Match(myStatus,'95','85','86','25');


      drop table table1;