topic How to set a table to another ? in QlikView

How to set a table to another ?

Tue, 09 Feb 2010 20:56:12 GMT

Hi,

I have 2 tables with exactly the same fields (Id & some other) and without deduplicate on Id field.

I just want to create a single table stacking both of them. I don't know how to do this.

Thanks for your help

Jean-Jacques

How to set a table to another ?

disqr_rm — Tue, 09 Feb 2010 20:58:53 GMT


BigTable:
LOAD * from Table1;
LOAD * from Table2;

If you have same fields in both tables, they will be automatically joined into one BigTable, as above. If you have any different field you would need to use CONCATENATE LOAD instead.

Hope this helps.

How to set a table to another ?

Tue, 09 Feb 2010 21:06:24 GMT

Thanks Rakesh

it works using CONCATENATE LOAD with exactly the same fields:

BigTable:
LOAD * from Table1;
CONCATENATE LOAD * from Table2;

JJ

How to set a table to another ?

johnw — Wed, 10 Feb 2010 00:11:35 GMT

The concatenate is optional if you have exactly the same fields. I would always use concatenate, because I like being very explicit about what I'm doing.

How to set a table to another ?

Wed, 10 Feb 2010 10:55:46 GMT

John, when i just do as Rakesh said, it doesn't work. I still have 2 table with link table $synth1 (all my fields). Maybe I did something wrong ?

Jean-Jacques

How to set a table to another ?

johnw — Wed, 10 Feb 2010 18:47:39 GMT

That's... very strange. In any case, while I can't explain it, the solution is to use concatenate, so I'd say you're good to go.