Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
micsim123
Contributor III
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

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

Hi Michael,

try this:

concatenate (FACT)

load *

resident FACT4;

drop table FACT4;

micsim123
Contributor III
Contributor III
Author

Hi Rodolfo

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

resident FACT4;


Regards

Michael

thiago_justen

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

thiago_justen

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
Contributor III
Contributor III

sorry Michael, I intended to say :

concatenate (FACT)

load *

Table4;

drop Table 4;

micsim123
Contributor III
Contributor III
Author

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

Don't mention it. Happy to help you.

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