Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
micsim123
New Contributor III

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

1 Solution

Accepted Solutions
thiago_justen
Valued Contributor III

Re: Concatenate resident table

Michael you are missing something...

The correct syntax here is:

Concatenate (TABLE_NAME)

Load

*

From OTHER_TABLE;

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
7 Replies
rodolfoag
New Contributor III

Re: Concatenate resident table

Hi Michael,

try this:

concatenate (FACT)

load *

resident FACT4;

drop table FACT4;

micsim123
New Contributor III

Re: Concatenate resident table

Hi Rodolfo

There is no FACT4 table, so it won't work with:

resident FACT4;


Regards

Michael

thiago_justen
Valued Contributor III

Re: Concatenate resident table

Michael you are missing something...

The correct syntax here is:

Concatenate (TABLE_NAME)

Load

*

From OTHER_TABLE;

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
thiago_justen
Valued Contributor III

Re: Concatenate resident table

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.

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
rodolfoag
New Contributor III

Re: Concatenate resident table

sorry Michael, I intended to say :

concatenate (FACT)

load *

Table4;

drop Table 4;

micsim123
New Contributor III

Re: Concatenate resident table

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.

thiago_justen
Valued Contributor III

Re: Concatenate resident table

Don't mention it. Happy to help you.

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago