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

    table concatenate creates two tables

    Andy Faulkner

      Hello

      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,

      Andy.

       

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

       

      drop table table1;