Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
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
Highlighted
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

View solution in original post

7 Replies
Highlighted
rodolfoag
New Contributor III

Re: Concatenate resident table

Hi Michael,

try this:

concatenate (FACT)

load *

resident FACT4;

drop table FACT4;

Highlighted
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

Highlighted
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

View solution in original post

Highlighted
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
Highlighted
rodolfoag
New Contributor III

Re: Concatenate resident table

sorry Michael, I intended to say :

concatenate (FACT)

load *

Table4;

drop Table 4;

Highlighted
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.

Highlighted
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