Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

siva_boggarapu
Contributor II

How to concatenate 4 tables

Hi All,

Please look at the file. I want to concatenate into single file

Please help me?

Thanks,

Siva

1 Solution

Accepted Solutions
siva_boggarapu
Contributor II

Re: How to concatenate 4 tables

Hi

Can you take my scrip. In First table I have 200 Records and 2nd table 200 records. When I use concatenation I am getting 200 records instead 400 records

IF possible can you send me script using my script

thanks

Siva

3 Replies
rittermd
Honored Contributor

Re: How to concatenate 4 tables

If two tables have the exact same layout (like a file for each year) then they will automatically concatenate unless you tell it not to.

If they don't have the same layout then you can code Concatenate in your script between the 2 files and they will do that. 

That is the simple answer.

siva_boggarapu
Contributor II

Re: How to concatenate 4 tables

Hi

Can you take my scrip. In First table I have 200 Records and 2nd table 200 records. When I use concatenation I am getting 200 records instead 400 records

IF possible can you send me script using my script

thanks

Siva

zebhashmi
Valued Contributor

Re: How to concatenate 4 tables

Can you share a sample qvf file

I would say User one table name

Like

[IntakePeriod]:

Load from table 1;

Load from Table 2;