two fact tables

[upaliwije]

Dear Friends

I have two fact tables with following fields

table 1

Dept,class,premium

table 2

Dept,Class,Vehicle Type, Claim Paid

When I concatenate two tables in my data model I m unable to extract a chart(straight Table) in following format

Vehicle Type,Premium,Claim Paid    (premium data shows zero value)

That is because vehicle type field does not  exists in table1.

Can someone please tell how to do this

[Anonymous]

Load a NULL value into a new field [Vehicle Type] in table one.

Here's an example:

concat_table:

load

     *,

    null() as [Vehicle Type]

resident table1

load

     *

resident table2

[Anonymous]

I guess you need join rather than concatenate.

Please rename class field so it is Class in both tables.  Fields "class" and "Class" are different.

[Anonymous]

Michael,

You're right. I didn't read the problem carefully enough. My solution wouldn't accomplish what Upali needed.

Brian