Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Expert,
I want to concatenate 3 fact tables having different structure,
Can you please suggest how to concatenate them.
Thanks,
Deepak
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;
The CONCATENATE (tablename) prefix on a LOAD statement will force concatenation of tables even if they have different field names.
-Rob
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
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;
Hi Deepak,
Problem Solved, please check attached.