
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Concatenate resident table
Hi!
In my load script I want to concatenate a previously loaded table to my one fact table. The scripts principle goes like this:
FACT:
Load *
From table1 ;
Concatenate FACT:
Load *
From table2;
Concatenate FACT:
Load *
From table3;
// Now I need to first load table4 without concatenation, and make some calculations i table4
NoConcatenate
Table4:
Load *
From table4;
At the end I now want to include Table4 in my FACT.
I have tried:
Concatenate FACT:
Load *
Resident Table4 ;
Drop Table Table4;
But it does not work. I lose all variables from table4
Any ideas?
Regards Michael
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Michael you are missing something...
The correct syntax here is:
Concatenate (TABLE_NAME)
Load
*
From OTHER_TABLE;
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Michael,
try this:
concatenate (FACT)
load *
resident FACT4;
drop table FACT4;

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Rodolfo
There is no FACT4 table, so it won't work with:
resident FACT4;
Regards
Michael


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Michael you are missing something...
The correct syntax here is:
Concatenate (TABLE_NAME)
Load
*
From OTHER_TABLE;
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Another important thing: concatenate only works with tables that have same fields names into them.
For instance:
Table_1:
Load
FIELD_1,
FIELD_ID
From DB;
Concatenate (Table_1)
Load
FIELD_2 AS FIELD_1,
FIELD_ID2 AS FIELD_ID
From DB1;
If it is not your case I'd suggest you Left Join tables.
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
sorry Michael, I intended to say :
concatenate (FACT)
load *
Table4;
drop Table 4;

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Thiago
You're right.
I should really pay more attention to the syntax details.
It works with:
Concatenate (FACT)
Load *
Resident Table4 ;
Instead of:
Concatenate FACT:
Load *
Resident Table4 ;
thanks.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Don't mention it. Happy to help you.
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I have a similar situation, but no matter what I try I can't get the Composite field to create. I'm sure I'm just missing something in the syntax, but I don't have enough experience to identify what the miss is. HELP!
