table concatenate creates two tables

[#1]

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;

[maxgro]

is this all your script?

[#3]

no, just before this I have:

qualify *;

Unqualify column1;

//column1 joins tableA and tableB

table1:

tableA

left join

tableB