table concatenate creates two tables

Fri, 04 Dec 2015 17:46:59 GMT

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;

Re: table concatenate creates two tables

maxgro — Fri, 04 Dec 2015 18:01:39 GMT

is this all your script?

Re: table concatenate creates two tables

Fri, 04 Dec 2015 18:06:10 GMT

no, just before this I have:

qualify *;

Unqualify column1;

//column1 joins tableA and tableB

table1:

tableA

left join

tableB

topic Re: table concatenate creates two tables in QlikView

table concatenate creates two tables

Re: table concatenate creates two tables

Re: table concatenate creates two tables