Discussion Board for collaboration on QlikView Scripting.
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?
[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;
is this all your script?
no, just before this I have:
//column1 joins tableA and tableB