This content has been marked as final. Show 2 replies
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?
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;