Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

table concatenate creates two tables

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;

2 Replies
MVP
MVP

Re: table concatenate creates two tables

is this all your script?

Not applicable

Re: table concatenate creates two tables

no, just before this I have:

qualify *;

Unqualify column1;

//column1 joins tableA and tableB

table1:

tableA

left join

tableB

Community Browser