Concatenation of 3 fact tables

[deepakqlikview_123]

Hello Expert,

I want to concatenate 3 fact tables having different structure,

Can you please suggest how to concatenate them.

Thanks,

Deepak

[rwunderlich]

The CONCATENATE (tablename) prefix on a LOAD statement will force concatenation of tables even if they have different field names.

-Rob

[deepakqlikview_123]

Hi Rob ,

Please find below syntax,

Table1:

No Concatenate,

Concatenate(Table1)

Select * from Resident Tablename,

Drop table Tablename1;

Concatenate(Table1)

Select * from Resident Tablename2,

Drop table Tablename2

Is this will work fine.Please suggest.

Thanks,

Deepak

[tresesco · Accepted solution]

You can simply write like:

Table1:

Load * from Resident Tablename;

Concatenate      // if you don't mention the table name here qv would concat it with the previous table

Load * from Resident Tablename2;

[engishfaque]

Hi Deepak,

Problem Solved, please check attached.