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

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

Fri, 24 Feb 2012 11:49:38 GMT

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.

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

jvitantonio — Fri, 24 Feb 2012 12:39:42 GMT

Yes, use concatenate

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

fernando_tonial — Fri, 24 Feb 2012 12:50:43 GMT

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.

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

Fri, 24 Feb 2012 13:22:23 GMT

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 ?