How add data in the same fact tables from a another tables ?

[#1]

Hi,

I have 2 tables fact (same name fields) :

for example :

FT1:

LOAD

Qty,Revenue, Gross Profit, ID_field1,D_field2,D_field3

FROM File1.xls;

FT2:

LOAD

Devise,Margin,ID_field1,D_field2,D_field3

RESIDENT File1.xls

Do I have to use ky word concatenate load ?

I want to put all fields from FT2 into FT1.

Thanks.

[jvitantonio]

Yes, use concatenate

[fernando_tonial]

See the example.

FT1:
LOAD
Qty,Revenue, [Gross Profit], ID_field1,D_field2,D_field3
FROM File1.xls;
Concatenate (FT1)
LOAD
Devise,Margin,ID_field1,D_field2,D_field3
RESIDENT File1.xls

Best Regards.

Tonial.

[#4]

in my table FT1, I have some units (Kg, DT, MG,...)

I create the folows query :

CONCATENATE  (FT1)

LOAD MRGTE as Units,

ATG,

PLIT

RESIDENT FT1;

I want to add (ATG,PLIT) in my FT1 table in the fields MRGTE as Units.

How Can I do that ?