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
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator 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
Creator II
Creator II

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

View solution in original post

3 Replies
Master
Master

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.

Creator II
Creator II

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

View solution in original post

Specialist
Specialist

Can you share a sample qvf file

I would say User one table name

Like

[IntakePeriod]:

Load from table 1;

Load from Table 2;