How to set a table to another ?

[#1]

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

[disqr_rm]

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.

[#3]

Thanks Rakesh

it works using CONCATENATE LOAD with exactly the same fields:

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

JJ

[johnw]

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.

[#5]

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

[johnw]

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.